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

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

From
tgl@postgresql.org (Tom Lane)
Date:
28 July 2006, 15:33:55
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)