lower integer bound not supported - Mailing list pgsql-bugs

From Sandro Santilli
Subject lower integer bound not supported
Date
Msg-id 20160608160800.GB13838@localhost
Whole thread Raw
Responses Re: lower integer bound not supported  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case in Order By Ignored without warning or error
Next
From: Alvaro Herrera
Date:
Subject: Re: lower integer bound not supported