DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type;
	b=qWlU36CK7sCoE9WL+VUXKhELsWABdbz5zl8fSNe9sRDczfJ+swiIMu34TDmJ3FvlPD
	LO7FCehV7r+vjEUnfaS7C083lr5YeNiCIspyODiOG3QIZrqSqCWMeLea27aEtrpqB2ix
	FqTy1FVqyEwo+fNPPv7EoQFO4ltwhjnnSAYL8=
MIME-Version: 1.0
In-Reply-To: <4C207B8B.4030104@gmail.com>
References: <4C207403.3080103@gmail.com>
	<AANLkTimwgKepmPoUE_JaBA-UsgXaXipNGVMUECUROYzA@mail.gmail.com>
	<AANLkTikurALoXoquO_9FQpUACFM63olN87ofi_zYGRJz@mail.gmail.com>
	<4C207B8B.4030104@gmail.com>
From: Thom Brown <thombrown@gmail.com>
Date: Tue, 22 Jun 2010 10:46:30 +0100
Message-ID: <AANLkTil8g4KBzILetkAnygNnltFKothMXfITfOH9FraR@mail.gmail.com>
Subject: Re: INTEGER range ("-2147483648" is not accepted.)
To: Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
Cc: Magnus Hagander <magnus@hagander.net>,
	pgsql-docs <pgsql-docs@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1

On 22 June 2010 09:59, Satoshi Nagayasu <satoshi.nagayasu@gmail.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