[HACKERS] integer input functions : interesting limit behaviour

I was looking in the int*in() functions and found some interesting limit behaviours : * Here, the most negative value is sometimes accepted, sometimes not : test= SELECT -2147483648::INTEGER; ERREUR: entier en dehors des limites test= SELECT '-2147483648'::INTEGER; int4 -

Re: [HACKERS] integer input functions : interesting limit behaviour

=?utf-8?Q?Pierre_Fr=C3=A9d=C3=A9ric_Caillau?= =?utf-8?Q?d?= li...@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