Обсуждение: SQL:2003 Statistical functions - What are they?
I'm not sure this is the right group to ask this. I see that the 8.2 notes say all SQL:2003 statistical functions are implemented in 8.2, but I couldn't find a listing for those anywhere I looked. For those who are clueless like me, can someone provide a listing of what these functions are? Thanks, Regina ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
On 10/4/06, Obe, Regina <robe.dnd@cityofboston.gov> wrote: > I'm not sure this is the right group to ask this. I see that the 8.2 > notes say all SQL:2003 statistical functions are implemented in 8.2, but > I couldn't find a listing for those anywhere I looked. > > For those who are clueless like me, can someone provide a listing of > what these functions are? look in the aggregate functions (9.15) section of the developers documentation. http://developer.postgresql.org/pgdocs/postgres/index.html However, the release notes mentioned array improvements and I didn't see anything in the documentation, are these functions listed somewhere? merlin
Merlin Moncure wrote: > On 10/4/06, Obe, Regina <robe.dnd@cityofboston.gov> wrote: > > I'm not sure this is the right group to ask this. I see that the 8.2 > > notes say all SQL:2003 statistical functions are implemented in 8.2, but > > I couldn't find a listing for those anywhere I looked. > > > > For those who are clueless like me, can someone provide a listing of > > what these functions are? > > > look in the aggregate functions (9.15) section of the developers documentation. > http://developer.postgresql.org/pgdocs/postgres/index.html > > However, the release notes mentioned array improvements and I didn't > see anything in the documentation, are these functions listed > somewhere? From release notes: <listitem> <para> Add SQL2003-standard statistical aggregates (Sergey Koposov) </para> <para> New functions: <function>regr_intercept()</>, <function>regr_slope()</>, <function>regr_r2()</>, <function>corr()</>, <function>covar_samp()</>, <function>covar_pop()</>, <function>regr_avgx()</>, <function>regr_avgy()</>, <function>regr_sxy()</>, <function>regr_sxx()</>, <function>regr_syy()</>, <function>regr_count()</>. </para> </listitem> -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
On Wed, Oct 04, 2006 at 08:46:14 -0400, "Obe, Regina" <robe.dnd@cityofboston.gov> wrote: > I'm not sure this is the right group to ask this. I see that the 8.2 > notes say all SQL:2003 statistical functions are implemented in 8.2, but > I couldn't find a listing for those anywhere I looked. > > For those who are clueless like me, can someone provide a listing of > what these functions are? They are grouped under aggregate functions. See: http://developer.postgresql.org/pgdocs/postgres/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE