pgsql/src/test/regress/sql (aggregates.sql create_aggregate.sql errors.sql oidjoins.sql opr_sanity.sql)

Started by Tom Laneover 26 years ago1 messagescommitters
Jump to latest
#1Tom Lane
tom_lane___@unknown.user

Date: Sunday, July 16, 2000 @ 23:05:40
Author: tgl

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

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

----------------------------- 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...