lower integer bound not supported

Поиск
Список
Период
Сортировка
От Sandro Santilli
Тема lower integer bound not supported
Дата
Msg-id 20160608160800.GB13838@localhost
обсуждение исходный текст
Ответы Re: lower integer bound not supported  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Case in Order By Ignored without warning or error
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: lower integer bound not supported