For query language (SQL) functions, what's the difference between the int
and integer
base types?
How do you know?
The difference between int and integer is that int is a data type, but integer is a group of data types – e.g. int , long , short and byte .
INTEGER is a 32-bit binary numeric type. It has a fixed storage size of 4 bytes. NUMBER is a new data type, introduced in Teradata 14.0, which is intended to emulate the Oracle number data type. It has an optional precision and scale of up to 38 decimal digits.
In Postgresql int
and int4
are aliases for integer
, a signed four-byte integer
http://www.postgresql.org/docs/current/static/datatype.html#DATATYPE-TABLE
Int and Integer are the same
"The keyword INT is a synonym for INTEGER"
Similarly
"The keywords DEC and FIXED are synonyms for DECIMAL"
Sql Numeric Documentation Source
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With