stddev_pop, stddev_samp strange behaviour - Mailing list pgsql-jdbc

From student23
Subject stddev_pop, stddev_samp strange behaviour
Date
Msg-id 1121e8e2.366a05c5.46922a35.dbe87@o2.pl
Whole thread Raw
List pgsql-jdbc
Hi,

I've created a test table with some random data and try to execute stddev_pop _samp, and var_pop _samp as below.

select stddev_pop(value),stddev_samp(value) from test
select var_pop(value),var_samp(value) from test

I noticed that stddev_pop return same value as stddev_samp, and var_pop return same value as var_samp. I have
PostgreSQL8.2.4 and asume something is wrong. The data I used should return different value for each function. 

MZ

pgsql-jdbc by date:

Previous
From: Altaf Malik
Date:
Subject: Unable to prepare a statement when the object names contain more than one $ symbol
Next
From: Kris Jurka
Date:
Subject: Re: Unable to prepare a statement when the object names contain more than one $ symbol