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

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to handle 'not a number' in postgresql
Date: 2008-01-04 14:35:50
Message-ID: Pine.LNX.4.64.0801040634220.5706@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2008-01-04 14:46:17 Re: How to handle 'not a number' in postgresql
Previous Message Magnus Hagander 2008-01-04 14:33:55 Re: Using syslog on pg for Windows