| From: | Sandro Santilli <strk(at)kbt(dot)io> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | lower integer bound not supported |
| Date: | 2016-06-08 16:08:00 |
| Message-ID: | 20160608160800.GB13838@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
According to documentation (from 9.1 to 9.5) the supported
integer ranges are these ones:
smallint 2 bytes -32768 to +32767
integer 4 bytes -2147483648 to +2147483647
bigint 8 bytes -9223372036854775808 to +9223372036854775807
But the lowest bound is not really supported:
# select -32768::int2;
ERROR: smallint out of range
# select -2147483648::int4;
ERROR: integer out of range
# select -9223372036854775808::int8;
ERROR: bigint out of range
This happens with server versions 9.1.22, 9.3.6 and 9.5(unspecified).
Is it the code or the documentation being broken ?
To me, the documentation makes the most sense, and the code is broken.
--strk;
() Free GIS & Flash consultant/developer
/\ https://strk.kbt.io/services.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2016-06-08 16:37:59 | Re: lower integer bound not supported |
| Previous Message | Tom Lane | 2016-06-08 14:32:52 | Re: Case in Order By Ignored without warning or error |