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:content-transfer-encoding;
	b=DvpkjKhQXRCD0e104GjWxD3h5DZNtLFgJg1qLjJDsRy0077exmxiYoTElXn9qBoJum
	On4AFKjyb8g+JaIhaviI12ogfvVRghESrWZulFrS8tEGrcHveYVWG8RCGg+Mk6CuHiYe
	PYlG61Vpgphg2eUszTiqG5nt8efEqDiZwOtvw=
MIME-Version: 1.0
In-Reply-To: <AANLkTil8g4KBzILetkAnygNnltFKothMXfITfOH9FraR@mail.gmail.com>
References: <4C207403.3080103@gmail.com>
	<AANLkTimwgKepmPoUE_JaBA-UsgXaXipNGVMUECUROYzA@mail.gmail.com>
	<AANLkTikurALoXoquO_9FQpUACFM63olN87ofi_zYGRJz@mail.gmail.com>
	<4C207B8B.4030104@gmail.com>
	<AANLkTil8g4KBzILetkAnygNnltFKothMXfITfOH9FraR@mail.gmail.com>
From: Thom Brown <thombrown@gmail.com>
Date: Tue, 22 Jun 2010 10:57:34 +0100
Message-ID: <AANLkTik1VOVpw9zE4iSoNAmo2AjXpLJyHf_qXJfv8vpL@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
Content-Transfer-Encoding: quoted-printable

On 22 June 2010 10:46, Thom Brown <thombrown@gmail.com> wrote:
> On 22 June 2010 09:59, Satoshi Nagayasu <satoshi.nagayasu@gmail.com> wrot=
e:
>> 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=3D# SELECT -2147483648;
> =A0?column?
> -------------
> =A0-2147483648
> (1 row)
>
> postgres=3D# SELECT pg_typeof(-2147483648);
> =A0pg_typeof
> -----------
> =A0integer
> (1 row)
>
> And just in case...
>
> postgres=3D# SELECT pg_typeof(test.my_num) FROM (SELECT -2147483648) AS
> test(my_num);
> =A0pg_typeof
> -----------
> =A0integer
> (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