Slight discrepancy

Поиск
Список
Период
Сортировка
Искать

Slight discrepancy

От:
Lyle <webmaster@cosmicperl.com>
Дата:
Here:
http://www.postgresql.org/docs/9.2/static/datatype-numeric.html

smallint2 bytessmall-range integer-32768 to +32767
integer4 bytestypical choice for integer-2147483648 to +2147483647
bigint8 byteslarge-range integer-9223372036854775808 to 9223372036854775807

The bigint maximum positive number doesn't have the + prefix like the others.


Lyle

Re: Slight discrepancy

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
On Sat, 2013-03-02 at 03:50 +0000, Lyle wrote:
> Here:
> http://www.postgresql.org/docs/9.2/static/datatype-numeric.html
> 
> smallint 	2 bytes 	small-range integer 	-32768 to +32767
> integer 	4 bytes 	typical choice for integer 	-2147483648 to +2147483647
> bigint 	8 bytes 	large-range integer 	-9223372036854775808 to 
> 9223372036854775807
> 
> 
> The bigint maximum positive number doesn't have the + prefix like the 
> others.

Fair enough.  Adjustment made.



FAQ