Postgres Pro
Downloads
Home   >   mailing lists

stddev returns 0 when there is one row - Mailing list pgsql-general

From Bruno Wolff III
Subject stddev returns 0 when there is one row
Date
Msg-id 20030419161121.GA31798@wolff.to
Whole thread Raw
Responses Re: stddev returns 0 when there is one row  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
Tree view 
stddev returns 0 when the number of rows is one. I would have expected null
to be returned in this case as the standard deviation is undefined when
there is one row.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: does parser still parse those comment out lines?
Next
From: davidgn@servidor.unam.mx
Date:
Subject: does parser still parse those comment out lines?