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: [EMAIL PROTECTED]
Index: ../src/backend/catalog/sql_features.txt
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/catalog/sql_features.txt,v
retrieving revision 1.14
diff -c -r1.14 sql_features.txt
*** ../src/backend/catalog/sql_features.txt     3 Mar 2006 04:31:07 -0000       
1.14
--- ../src/backend/catalog/sql_features.txt     31 Jul 2006 09:14:51 -0000
***************
*** 429,435 ****
  T611  Elementary OLAP operations                      NO      
  T612  Advanced OLAP operations                        NO      
  T613  Sampling                        NO      
! T621  Enhanced numeric functions                      NO      
  T631  IN predicate with one list element                      NO      
  T641  Multiple column assignment                      NO      
  T651  SQL-schema statements in SQL routines                   NO      
--- 429,435 ----
  T611  Elementary OLAP operations                      NO      
  T612  Advanced OLAP operations                        NO      
  T613  Sampling                        NO      
! T621  Enhanced numeric functions                      YES     
  T631  IN predicate with one list element                      NO      
  T641  Multiple column assignment                      NO      
  T651  SQL-schema statements in SQL routines                   NO      
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to