Re: How to handle 'not a number' in postgresql

From: Michael Glaesemann <michael(dot)glaesemann(at)myyearbook(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to handle 'not a number' in postgresql
Date: 2008-01-04 14:46:17
Message-ID: E175CBF8-1961-418E-9D27-6F3311BF71CF@myyearbook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(dot)glaesemann(at)myyearbook(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2008-01-04 15:00:13 Re: How to handle 'not a number' in postgresql
Previous Message Rich Shepard 2008-01-04 14:35:50 Re: How to handle 'not a number' in postgresql