Re: integer input functions : interesting limit behaviour - Mailing list pgsql-hackers

Pierre Frédéric Caillaud <lists@peufeu.com> 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