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

From thereverandpdawg
Subject How to handle 'not a number' in postgresql
Date
Msg-id fd3b3147-4fb3-4bc6-a148-1b7c14ae6c9a@b40g2000prf.googlegroups.com
Whole thread Raw
Responses Re: How to handle 'not a number' in postgresql
Re: How to handle 'not a number' in postgresql
List pgsql-general
I am new to this group so forgive me if this is the wrong area to post
in.

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.

TIA


pgsql-general by date:

Previous
From: dananrg@yahoo.com
Date:
Subject: Best free open source ER diagram generator?
Next
From:
Date:
Subject: Mandatory AS keyword in SELECT statements