On Fri, Dec 28, 2007 at 10:22:03AM -0800, 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.
Did you try it?
# select 'nan'::float;
float8
--------
NaN
(1 row)
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
