Re: [SQL] aggregate function stddev

2004-09-10 Thread Bruce Momjian
Is this a TODO? --- Josh Berkus wrote: > Kemin, > > > Just noticed that the postgres stddev is the stddev_sample formula. > > There are two different ways to calculate this value. > > Their difference is very small with lar

Re: [SQL] aggregate function stddev

2004-09-09 Thread Josh Berkus
Kemin, > Just noticed that the postgres stddev is the stddev_sample formula. > There are two different ways to calculate this value. > Their difference is very small with large samle size. It would be nice > to distinguish the two different versions. Note sent to PGSQL-DOCS. > I also noticed th

[SQL] aggregate function stddev

2004-09-08 Thread Kemin Zhou
Implementers: Just noticed that the postgres stddev is the stddev_sample formula. There are two different ways to calculate this value. Their difference is very small with large samle size. It would be nice to distinguish the two different versions. I also noticed that oracle has stddev_sampl