Postgres Pro
Downloads
Home   >   mailing lists

pgsql/src/test/regress/expected (aggregates.out create_aggregate.out errors.out oidjoins.out opr_sanity.out) - Mailing list pgsql-committers

From Tom Lane
Subject pgsql/src/test/regress/expected (aggregates.out create_aggregate.out errors.out oidjoins.out opr_sanity.out)
Date
Msg-id 200007170305.e6H35c926391@hub.org
Whole thread Raw
List pgsql-committers
Tree view 
  Date: Sunday, July 16, 2000 @ 23:05:37
Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/src/test/regress/expected
     from hub.org:/home/projects/pgsql/tmp/cvs-serv25842/src/test/regress/expected

Modified Files:
    aggregates.out create_aggregate.out errors.out oidjoins.out
    opr_sanity.out

-----------------------------  Log Message  -----------------------------

Revise aggregate functions per earlier discussions in pghackers.
There's now only one transition value and transition function.
NULL handling in aggregates is a lot cleaner.  Also, use Numeric
accumulators instead of integer accumulators for sum/avg on integer
datatypes --- this avoids overflow at the cost of being a little slower.
Implement VARIANCE() and STDDEV() aggregates in the standard backend.

Also, enable new LIKE selectivity estimators by default.  Unrelated
change, but as long as I had to force initdb anyway...

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql/src/pl/tcl/test (test_setup.sql)
Next
From: Tom Lane
Date:
Subject: pgsql/src/test/regress/sql (aggregates.sql create_aggregate.sql errors.sql oidjoins.sql opr_sanity.sql)