On 22 June 2010 10:46, Thom Brown <[email protected]> wrote: > On 22 June 2010 09:59, Satoshi Nagayasu <[email protected]> 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 >
Actually, come to think of it, shouldn't we have a gotchas page on the wiki? Thom -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
