Re: [HACKERS] SQL:2003 Statistical functions - What are they?
On Wed, Oct 04, 2006 at 08:46:14 -0400, "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? They are grouped under aggregate functions. See: http://developer.postgresql.org/pgdocs/postgres/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] SQL:2003 Statistical functions - What are they?
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: Add SQL2003-standard statistical aggregates (Sergey Koposov) New functions: regr_intercept(), regr_slope(), regr_r2(), corr(), covar_samp(), covar_pop(), regr_avgx(), regr_avgy(), regr_sxy(), regr_sxx(), regr_syy(), regr_count(). -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://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
Re: [HACKERS] SQL:2003 Statistical functions - What are they?
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? merlin ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] 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. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster