RE: [HACKERS] Numeric with '-'

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: <bhirt(at)mobygames(dot)com>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: RE: [HACKERS] Numeric with '-'
Date: 2000-02-21 08:53:20
Message-ID: 000601bf7c49$1a6bea40$2801007e@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Brian Hirt [mailto:bhirt(at)mobygames(dot)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(at)tpf(dot)co(dot)jp

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-02-21 09:00:51 Re: [HACKERS] Numeric with '-'
Previous Message Brian Hirt 2000-02-21 07:54:37 Re: [HACKERS] Numeric with '-'