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.htmlHowever, 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