Re: Re: [GENERAL] +/- Inf for float8's - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Re: [GENERAL] +/- Inf for float8's
Date
Msg-id 39997586.1D1B55B5@alumni.caltech.edu
Whole thread Raw
In response to Re: [GENERAL] +/- Inf for float8's  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Responses Re: Re: [GENERAL] +/- Inf for float8's  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> So, anyone have any ideas what NaN would be useful for? Especially given
> we have NULL available, which most (non DB) numeric applications don't.

Hmm. With Tom Lane's new fmgr interface, you *can* return NULL if you
spot a NaN result. Maybe that is the best way to go about it; we'll
stipulate that NaN and NULL are equivalent. And we'll further stipulate
that if you are messing with NaN then you deserve what you get ;)
                      - Thomas


pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Re: [GENERAL] +/- Inf for float8's
Next
From: Thomas Lockhart
Date:
Subject: Re: Open Source Database Routs Competition in New Benchmark Tests