From:
Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To:
Peter Eisentraut <peter_e(at)gmx(dot)net>, 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-05 03:07:04
Message-ID:
3B1C4CD8.4301C97C@fourpalms.org (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
> > -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.
I'd like to see the distinction between NaN and NULL retained, since the
two "values" arise from different circumstances and under different
conditions. If a particular app needs them to be equivalent, then that
is easy enough to do with SQL or triggers.
- Thomas
On a modestly related note, I'm come over to the notion that the
date/time value 'current' could be ripped out eventually. Tom, isn't
that the only case for those types which bolluxes up caching of
date/time types?
In response to
Responses
pgsql-hackers by date
Next :From: chris.bitmeadDate: 2001-06-05 03:08:58Subject : Re: Question about inheritancePrevious :From : bpalmerDate : 2001-06-05 02:24:51Subject : Re: Mirrors not tracking main ftp site?
