Tutorial 20 - Numeric Data Types Video Lecture | Postgresql: A Complete Tutorial - Database Management

hello in this tutorial I'm going to talk
about the numeric data type and
PostgreSQL
so we were talking about data types such
as integer numerator type II until type
and serial data type so I will mention
this to weld size the description and
the range of each and every drill type
in detail in the description given below
so you could check it there so first of
all we are going to speak about the
small end that is the interior type so
small enter can have a value of minus
three two seven six seven two 32767 and
it can store two bytes of data so first
I'm going to tell you how to declare a
small int so first of all we gonna make
and see that we have a table so I will
make one other table and I will give it
test table you could say and I had to
call them here that will be primary key
that is right and we'll give it a
privilege of primary Cattleya stage data
type would be integer type number and
next we'll build another column for
testing that is testing and data type
would very first of all you can see that
I will add the small end so you can see
that small end and when you click OK
all right this Morland you would see
that a small in has been created now I
will be adding the primary key for this
for that you can add constraints add
columns you could go and try as the
primary key and now I could add results
here so you would see one and if this is
a small in number this has to be in a
range of 32,767 so first of all I will
enter 3 - 7 6 7 that is the maximum
range it
enter now if I enter it you would see
that it gives me an error that it is out
of range for small end so the next type
will be the interior type that can have
value up to two billion so I will
mention the range given below and I will
tell you how to declare it so as you can
see I have a data of small end data type
of testing table now is change it to
India real type so you could just write
integer so with integer we have a range
up to two billion we will just see it
now and if you see that you will click
on two and you will enter integer so the
range would be two one four seven four
eight three six four seven so this is
the range there is a maximum range now
if I put it you would see that it is out
of range so this is the use of Imperial
type in our column so next you could be
using the big int if you want even
bigger dental type that would be till 9
quintillion so you could use begin big
int in that case so in the next next
thing that is going to talk about is the
numeric data type so it has variable
size and it is used to store decimal
values such as the price so I will tell
you how to declare a numeric Linotype so
so now as you can see that I will be
putting this as the numerator type you
could put numeric and you will click on
OK so it has created a new material type
now to enter values you would see that I
can put anything such as forty five
point something something so this will
store the price data type or equals to
four to five point nine with any decimal
precision so this is the use of numeric
data type so next we will speak about
the real data type that has four bytes
of data and it can store decimals up to
four digits of decimal places so you
could also use double precision that
will be eight bytes and it has fifteen
Cemal precision I will just show you how
to make that kind of a teletype so now
we have new material type now I will
change it to real teletype and you could
see the real data type gives me
provision to store data up to four four
decimal places or a precision of four
decimal places so you will see that I
will enter anything there is three and I
will enter forty six forty five point
number that is greater than four so you
could see its tools now and you could
see that it gives me a four decimal
precision automatically so this is the
use of the real if you want it to be a
bigger number or you want more decimal
precision than that you could just add
it as double precision and it is so this
will give you a precision up to 15
decimal places and lastly we'll be
talking about the serial data type so
first of course we will talk about the
small sealed end type which is of two
bytes and the range is small and the
ranges of 32,767 as that of the small
India type so the role of our serial
type is to basically automatically
increment itself so we will just see it
if I use small serial and I click on
okay so you will see that this will
increment itself automatically and I put
just into my values there and you can
see it is automatically incrementing one
two three and if I put anything such as
nine it will automatically increment as
four then I put anything I should 27 it
will automatically increment and
automatic increment so this is the use
of the seal datatype so from the from
this tutorial onwards you will know the
actual power of PostgreSQL and what it
is capable of so you could also use the
serial type and the big serial type of
four and eight bytes respectively and
the range of them are of that integer
and big integer respectively so you can
see
you could just into properties and you
put just the serial air to give the
serial type and if you want the big
serial you can just click on the big
serial so thank you for watching still
you guys next in the next video we are
talking about the enumeration data type
in PostgreSQL don't forget to subscribe
and stay tuned