Re: Re: [GENERAL] +/- Inf for float8's
From:
Peter Eisentraut <peter_e(at)gmx(dot)net>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>,
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,
Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>,
<pgsql-hackers(at)postgreSQL(dot)org>
Subject:
Re: Re: [GENERAL] +/- Inf for float8's
Date:
2001-06-02 20:50:03
Message-ID:
Pine.LNX.4.30.0106022243150.23690-100000@peter.localdomain (view raw or flat )
Thread:
2000-08-14 18:38:58 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-15 03:27:55 from Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
2000-08-15 16:21:57 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-19 22:33:00 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2000-08-20 22:08:28 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-21 05:25:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-08-21 16:59:13 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-21 17:39:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-08-21 19:32:08 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-21 20:37:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-08-21 22:30:21 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-21 22:59:02 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-21 23:12:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-08-21 20:49:51 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-21 21:34:50 from "Henry B(dot) Hotz" <hotz(at)jpl(dot)nasa(dot)gov>
2000-08-22 19:34:31 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-23 06:23:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-08-22 15:46:35 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-10-12 04:16:42 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2000-10-12 14:56:57 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-06-02 20:31:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-06-02 20:50:03 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-06-02 21:11:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-06-05 03:07:04 from Thomas Lockhart <lockhart(at)fourpalms(dot)org>
2001-06-05 04:21:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-08-19 23:26:44 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-20 00:01:37 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-20 00:07:01 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-20 00:34:43 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-20 00:43:13 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-20 02:52:52 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-20 03:02:35 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-20 03:20:08 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-20 01:22:39 from Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
2000-08-20 01:28:54 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-20 03:07:21 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-20 05:10:54 from Ben Adida <ben(at)openforce(dot)net>
2000-08-20 05:25:16 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-20 03:22:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-08-20 05:15:57 from Ben Adida <ben(at)openforce(dot)net>
2000-08-21 01:44:49 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-21 02:22:27 from Ned Lilly <ned(at)greatbridge(dot)com>
2000-08-21 13:59:06 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-21 14:35:10 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-21 17:28:18 from Adam Haberlach <adam(at)newsnipple(dot)com>
2000-08-21 18:34:45 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-22 00:35:22 from Adam Haberlach <adam(at)newsnipple(dot)com>
2000-08-22 00:40:38 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-22 00:50:05 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-22 03:40:26 from Mike Mascari <mascarm(at)mascari(dot)com>
2000-08-21 14:48:17 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 15:01:49 from Ben Adida <ben(at)openforce(dot)net>
2000-08-21 15:12:51 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 18:00:44 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-21 18:50:13 from Alfred Perlstein <bright(at)wintelcom(dot)net>
2000-08-21 18:58:03 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 19:30:46 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-21 19:47:33 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 20:17:30 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2000-08-21 19:36:12 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-21 19:45:36 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2000-08-21 19:54:04 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-21 17:47:41 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-21 18:54:12 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 20:04:37 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-21 20:13:47 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 20:20:59 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-21 20:26:59 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 20:32:01 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-21 20:37:42 from Vince Vielhaber <vev(at)michvhf(dot)com>
2000-08-21 20:22:08 from Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
2000-08-21 19:24:49 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-20 05:20:19 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-20 09:18:28 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2000-08-20 11:19:35 from Wim Ceulemans <Wim(dot)Ceulemans(at)nice(dot)be>
2000-08-20 20:37:30 from "David Lloyd-Jones" <icomm5(at)attcanada(dot)ca>
2000-08-20 22:48:23 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-21 20:09:54 from "Henry B(dot) Hotz" <hotz(at)jpl(dot)nasa(dot)gov>
2000-08-21 20:16:55 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-21 21:01:32 from "Henry B(dot) Hotz" <hotz(at)jpl(dot)nasa(dot)gov>
2000-08-21 20:24:04 from Jan Wieck <janwieck(at)Yahoo(dot)com>
2000-08-21 20:15:37 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-23 08:06:47 from Hannu Krosing <hannu(at)tm(dot)ee>
2000-08-20 14:17:28 from The Hermit Hacker <scrappy(at)hub(dot)org>
2000-08-15 16:33:27 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2000-08-15 16:53:26 from Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
2000-08-19 22:33:49 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2000-08-15 16:57:30 from "Timothy H(dot) Keitt" <keitt(at)nceas(dot)ucsb(dot)edu>
2000-08-15 17:25:06 from Oliver Seidel <seidel(at)in-medias-res(dot)com>
2000-08-15 17:07:39 from Thomas Swan <tswan-lst(at)tangent(dot)ics(dot)olemiss(dot)edu>
Lists:
pgsql-hackers
Tom Lane writes:
> [ continuing a discussion from last August ]
[I was *just* thinking about this. Funny.]
> I believe that's not a problem anymore. The current form of the float
> comparison functions will perform sorting and comparisons according to
> the sequence
>
> -infinity < normal values < infinity < NaN < NULL
I was thinking about making NaN equivalent to NULL. That would give
consistency in ordering, and probably also in arithmetic. Additionally,
if the platform supports it we ought to make the Invalid Operation FP
exception (which yields NaN) configurable: either get NULL or get an
error.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2001-06-02 21:11:00Subject : Re: Re: [GENERAL] +/- Inf for float8's Previous :From : Tom LaneDate : 2001-06-02 20:31:27Subject : Re: Re: [GENERAL] +/- Inf for float8's
