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

Started by Tom Laneover 20 years ago1 messagescommitters
Jump to latest
#1Tom Lane
tgl@postgresql.org

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)