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

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 <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy