DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=XkWqMN3Fz2FNNPQ0c8vVQq+gyhH77OBWYu4GZQe8dfIAIjzwoRqlsNTu0SxhjPgaax
	55dALhFFRgYDR/JTJ7Q4bBHL6odOWX3QmsCQNUgY4r6+YXRk1lZl2IsUiBPbqUWi20pm
	/DYSDkOGNClHYxSx8D9+lDvJuKr5A3W0kKZsM=
Message-ID: <4C20BCA9.9050400@gmail.com>
Date: Tue, 22 Jun 2010 22:37:45 +0900
From: Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ja;
	rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5
MIME-Version: 1.0
To: Thom Brown <thombrown@gmail.com>
CC: Magnus Hagander <magnus@hagander.net>,
	pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: INTEGER range ("-2147483648" is not accepted.)
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>
	<AANLkTik1VOVpw9zE4iSoNAmo2AjXpLJyHf_qXJfv8vpL@mail.gmail.com>
In-Reply-To: <AANLkTik1VOVpw9zE4iSoNAmo2AjXpLJyHf_qXJfv8vpL@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thom,

> Actually, come to think of it, shouldn't we have a gotchas page on the wiki?

I agree with that it should be described in some tech document,
but I don't have any good idea where/how it should be written.

Basically, it's a parser issue, but app developers may meet it
on their type casting (my guess), and it's a bit tricky.

Regards,

On 2010/06/22 18:57, Thom Brown wrote:
> On 22 June 2010 10:46, Thom Brown<thombrown@gmail.com>  wrote:
>> 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
>>
>
> Actually, come to think of it, shouldn't we have a gotchas page on the wiki?
>
> Thom
>


-- 
NAGAYASU Satoshi <satoshi.nagayasu@gmail.com>