Re: numeric input changes

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: numeric input changes
Date: 2004-03-10 22:05:17
Message-ID: Pine.LNX.4.44.0403102302190.13979-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Wed, 10 Mar 2004, Tom Lane wrote:

> > nconway=# select 'Infinity'::float8;
> > ERROR: type "double precision" value out of range: overflow
>
> This works in 7.4 and older releases. Sounds to me like you broke it.

It does not work on 7.3 and 7.4 when I try.

Looking at the currect cvs code it's not just parsing 'Infinity' as a
value, there is also an overflow check after float operations that will
exclude Infinity and Nan.

By the way, this thing was discussed on irc and I just sent a mail on
-hackers about it, not knowing about this thread here.

There are too many lists :-)

--
/Dennis Björklund

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-03-10 22:06:43 Re: numeric input changes
Previous Message Shachar Shemesh 2004-03-10 22:03:32 Defining a "tinyint" data type - one byte unsigned