=?utf-8?Q?Pierre_Fr=C3=A9d=C3=A9ric_Caillau?= =?utf-8?Q?d?= <[email protected]>
writes:
> * Here, the most negative value is sometimes accepted, sometimes not :
> test=> SELECT -2147483648::INTEGER;
> ERREUR: entier en dehors des limites
You're confused about the operator precedence: the above is
treated as -(2147483648::INTEGER) so of course it fails.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
