stddev returns 0 when there is one row

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: stddev returns 0 when there is one row
Date: 2003-04-19 16:11:21
Message-ID: 20030419161121.GA31798@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message davidgn 2003-04-19 17:31:43 does parser still parse those comment out lines?
Previous Message Tom Lane 2003-04-19 15:58:48 Re: [SQL] Yet Another (Simple) Case of Index not used