From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Satoshi Nagayasu <satoshi(dot)nagayasu(at)gmail(dot)com> |
Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-docs <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: INTEGER range ("-2147483648" is not accepted.) |
Date: | 2010-06-22 09:57:34 |
Message-ID: | AANLkTik1VOVpw9zE4iSoNAmo2AjXpLJyHf_qXJfv8vpL@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On 22 June 2010 10:46, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> On 22 June 2010 09:59, Satoshi Nagayasu <satoshi(dot)nagayasu(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Tolley | 2010-06-22 12:56:11 | Re: hot standby documentation |
Previous Message | Thom Brown | 2010-06-22 09:46:30 | Re: INTEGER range ("-2147483648" is not accepted.) |