Re: NaN with STDDEV() with mixed ::float4 ::float8 values

From: Thomas Lockhart <thomas(at)fourpalms(dot)org>
To: Jon Lapham <lapham(at)extracta(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: NaN with STDDEV() with mixed ::float4 ::float8 values
Date: 2002-04-03 15:01:54
Message-ID: 3CAB1962.95726DD5@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mlw 2002-04-03 15:02:15 Re: Suggestions please: names for function cachability attributes
Previous Message Samuel J. Sutjiono 2002-04-03 14:59:28 Logging option