Merlin Moncure wrote:
> On 10/4/06, Obe, Regina <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
