Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: How to handle 'not a number' in postgresql
Date
Msg-id Pine.LNX.4.64.0801040634220.5706@salmo.appl-ecosys.com
Whole thread Raw
In response to How to handle 'not a number' in postgresql  (thereverandpdawg <reverandpdawg@gmail.com>)
Responses Re: How to handle 'not a number' in postgresql
List pgsql-general
Tree view 
On Fri, 28 Dec 2007, thereverandpdawg wrote:

> I have some field data which comes off of a data logger. In some cases
> the data is out of bounds of logger or instrumentation. In which case
> it is reported as 'NaN' for 'not a number.'
>
> Is there such a value in postgresql? If not I will have to hack it in
> with a boolean and would rather not do so.

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

Rich

--
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Using syslog on pg for Windows
Next
From: Michael Glaesemann
Date:
Subject: Re: How to handle 'not a number' in postgresql