Thread: Slight discrepancy

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.


Lyle

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.