Postgres Pro
Downloads
Home   >   mailing lists

Re: How to handle 'not a number' in postgresql - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: How to handle 'not a number' in postgresql
Date
Msg-id E175CBF8-1961-418E-9D27-6F3311BF71CF@myyearbook.com
Whole thread Raw
In response to Re: How to handle 'not a number' in postgresql  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: How to handle 'not a number' in postgresql  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view 
On Jan 4, 2008, at 9:35 AM, Rich Shepard wrote:

>  It would be appropriate to convert NaN to NULL since the valid is
> literally unknown.

It's not unknown: it's known to be something other than a number,
which is not the same as unknown.

*considers quoting Rumsfield, but common sense prevails*

Michael Glaesemann
michael.glaesemann@myyearbook.com

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: How to handle 'not a number' in postgresql
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Best free open source ER diagram generator?