On 10/31/2014 07:58 AM, Filip Rembiałkowski wrote:
> psql.bin (9.3.4, server 9.3.5)
> Type "help" for help.
>
> dev=# select (2^63-1)::INT8;
> ERROR: bigint out of range
>
>
>
>
>
> Does it HAVE to be so?
No, figured it out:
test=# select ((2^63-1)::numeric); numeric
--------------------- 9223372036854780000
is rounding up.
To get what you want:
test=# select (2^63::numeric-1)::int8; int8
--------------------- 9223372036854775807
(1 row)
>
>
> http://en.wikipedia.org/wiki/9223372036854775807
>
>
>
> Thanks
> Filip
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com