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. +