Re: SQL:2003 Statistical functions - What are they?

Merlin Moncure wrote:
> On 10/4/06, Obe, Regina <robe(dot)dnd(at)cityofboston(dot)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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +