Postgres Pro
Downloads
Home   >   mailing lists

Re: NaN with STDDEV() with mixed ::float4 ::float8 values - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: NaN with STDDEV() with mixed ::float4 ::float8 values
Date
Msg-id 3CAB1962.95726DD5@fourpalms.org
Whole thread Raw
In response to NaN with STDDEV() with mixed ::float4 ::float8 values  (Jon Lapham <lapham@extracta.com.br>)
List pgsql-general
Tree view 
>    While computing standard deviation on a float8 column, I noticed that
> sometimes STDDEV returned "NaN".  I've tracked down the cause and
> thought I'd show everyone.  This may or may not be a bug, I don't know.

This was fixed for PostgreSQL version 7.2 afaict. Time to upgrade if you
are not running that version, and let us know if you already are running
it and we'll look into it further.

fwiw, I cannot reproduce the problem on my Linux box running 7.2.

Regards.

                      - Thomas

pgsql-general by date:

Previous
From: Jon Lapham
Date:
Subject: NaN with STDDEV() with mixed ::float4 ::float8 values
Next
From: "Samuel J. Sutjiono"
Date:
Subject: Logging option