Re: INTEGER range ("-2147483648" is not accepted.)

On 22 June 2010 09:59, Satoshi Nagayasu <satoshi(dot)nagayasu(at)gmail(dot)com> wrote:
> Magnus,
>
> Thanks for your advice. I've understood how it happens.
>
> However, it looks tricky and difficult to understand,
> so I hope that the message could be more understandable
> as Thom mentioned.
>
> Regards,
>

This does appear to be a gotcha, as the following returns a negative
integer as expected:

postgres=# SELECT -2147483648;
?column?
-------------
-2147483648
(1 row)

postgres=# SELECT pg_typeof(-2147483648);
pg_typeof
-----------
integer
(1 row)

And just in case...

postgres=# SELECT pg_typeof(test.my_num) FROM (SELECT -2147483648) AS
test(my_num);
pg_typeof
-----------
integer
(1 row)

So it's affected by the cast operator?

Thom