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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to