From: | "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | SQL conformance, optional feature T621 |
Date: | 2006-08-02 20:18:04 |
Message-ID: | Pine.LNX.4.64.0607311308440.30743@lnfm1.sai.msu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Hello,
After my & Tom's patch implementing the multi-argument aggregates it seems
that we have fully completed the optional feature T621 of the SQL 2003
standart:
195) Specifications for Feature T621, ?Enhanced numeric functions?:
a) Subclause 6.27, ?<numeric value function>?:
i) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain a <natural logarithm>.
ii) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain an <exponential function>.
iii) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain a <power function>.
iv) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain a <square root>.
v) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain a <floor function>.
vi) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain a <ceiling function>.
b) Subclause 10.9, ?<aggregate function>?:
i) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain a <computational operation> that immediately
contains STDDEV_POP, STDDEV_SAMP, VAR_POP, or VAR_SAMP.
ii) Without Feature T621, ?Enhanced numeric functions?, conforming SQL
language shall not contain a <binary set function type>,
where
<binary set function type> ::=
COVAR_POP
| COVAR_SAMP
| CORR
| REGR_SLOPE
| REGR_INTERCEPT
| REGR_COUNT
| REGR_R2
| REGR_AVGX
| REGR_AVGY
| REGR_SXX
| REGR_SYY
| REGR_SXY
Objections ?
So, I'm sending the patch for the sql_features.txt
Regards,
Sergey
*******************************************************************
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math(at)sai(dot)msu(dot)ru
Attachment | Content-Type | Size |
---|---|---|
sql.diff | text/plain | 1.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Seltenreich | 2006-08-02 23:35:05 | GIN vs. statistics collector |
Previous Message | Tom Lane | 2006-08-02 19:18:26 | Re: Values list-of-targetlists patch for comments (was Re: |