Re: [HACKERS] Numeric with '-'

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.

On Mon, Feb 21, 2000 at 04:06:07PM +0900, Hiroshi Inoue wrote:
> Hi,
>
> The following phenomenon was reported to pgsql-jp(ML in Japan).
>
> rest=# select -1234567890.1234567;
> ERROR: Unable to convert left operator '-' from type 'unknown'
>
> -1234567890.1234567 is treated as - '1234567890.1234567'
> as the following comment in scan.l says.
>
> /* we no longer allow unary minus in numbers.
> * instead we pass it separately to parser. there it gets
> * coerced via doNegate() -- Leon aug 20 1999
> */
>
> However doNegate() does nothing for SCONST('1234567890.1234567').
> I don't understand where or how to combine '-' and numeric SCONST.
>
> Regards.
>
> Hiroshi Inoue
> Inoue(at)tpf(dot)co(dot)jp
>
> ************

--
The world's most ambitious and comprehensive PC game database project.

http://www.mobygames.com