pgsql: SQL2003-standard statistical aggregates, by Sergey Koposov.

Started by Tom Lanealmost 20 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Log Message:
-----------
SQL2003-standard statistical aggregates, by Sergey Koposov. I've added only
the float8 versions of the aggregates, which is all that the standard requires.
Sergey's original patch also provided versions using numeric arithmetic,
but given the size and slowness of the code, I doubt we ought to include
those in core.

Modified Files:
--------------
pgsql/doc/src/sgml:
func.sgml (r1.327 -> r1.328)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.327&r2=1.328)
pgsql/src/backend/utils/adt:
float.c (r1.127 -> r1.128)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/float.c.diff?r1=1.127&r2=1.128)
int8.c (r1.60 -> r1.61)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/int8.c.diff?r1=1.60&r2=1.61)
pgsql/src/include/catalog:
catversion.h (r1.342 -> r1.343)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.342&r2=1.343)
pg_aggregate.h (r1.56 -> r1.57)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_aggregate.h.diff?r1=1.56&r2=1.57)
pg_proc.h (r1.418 -> r1.419)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.418&r2=1.419)
pgsql/src/include/utils:
builtins.h (r1.280 -> r1.281)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h.diff?r1=1.280&r2=1.281)
int8.h (r1.44 -> r1.45)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/int8.h.diff?r1=1.44&r2=1.45)
pgsql/src/test/regress/expected:
aggregates.out (r1.14 -> r1.15)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/aggregates.out.diff?r1=1.14&r2=1.15)
opr_sanity.out (r1.65 -> r1.66)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/opr_sanity.out.diff?r1=1.65&r2=1.66)
pgsql/src/test/regress/sql:
aggregates.sql (r1.12 -> r1.13)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/aggregates.sql.diff?r1=1.12&r2=1.13)
opr_sanity.sql (r1.51 -> r1.52)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/opr_sanity.sql.diff?r1=1.51&r2=1.52)