RE: [HACKERS] Numeric with '-' - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: [HACKERS] Numeric with '-'
Date
Msg-id 000601bf7c49$1a6bea40$2801007e@tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] Numeric with '-'  (Brian Hirt <bhirt@mobygames.com>)
List pgsql-hackers
> -----Original Message-----
> From: Brian Hirt [mailto:bhirt@mobygames.com]
> 
> A strange thing I noticed with this is that
> 
> "select -234567890.1234567;" works and
> "select -1234567890.123456;" also works while
> "select -1234567890.1234567;" does not.  That
> extra character just seems to push things over
> the edge.
> 
> It almost seems like there is some sort of length
> restriction somewhere in the parser.
>

Currently numeric constants are FLOAT8 constants if the
the precision <= 17 otherwise string constants.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp 



pgsql-hackers by date:

Previous
From: Brian Hirt
Date:
Subject: Re: [HACKERS] Numeric with '-'
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Numeric with '-'