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
