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,
On 2010/06/22 17:48, Thom Brown wrote:
On 22 June 2010 09:44, Magnus Hagander<[email protected]> wrote:
On Tue, Jun 22, 2010 at 10:27 AM, Satoshi Nagayasu
<[email protected]> wrote:
Hi all,
I've found a bit strange thing on the INTEGER range in the official manual.
http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html
According to the official manual, the INTEGER range is "-2147483648 to
+2147483647".
However, my example in below shows that "-2147483648" is not accepted.
Is this correct? Any suggestions?
template1=# SELECT -2147483648::integer;
ERROR: integer out of range
This gets parsed as "cast 2147483648 to integer
Why? And if so, it would probably be more useful if the error message
was something more like:
ERROR: integer 2147483648 out of range
That would at least show the user what the value was seen as by the parser.
Thom
--
NAGAYASU Satoshi <[email protected]>
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
