delta/postgresql.git/src/test/regress/sql/aggregates.sql, branch WIN32_DEV

Implement outer-level aggregates to conform to the SQL spec, with

2003-06-06T15:04:03+00:00

extensions to support our historical behavior.  An aggregate belongs
to the closest query level of any of the variables in its argument,
or the current query level if there are no variables (e.g., COUNT(*)).
The implementation involves adding an agglevelsup field to Aggref,
and treating outer aggregates like outer variables at planning time.

Finish implementation of hashed aggregation. Add enable_hashagg GUC

2002-11-21T00:42:20+00:00

parameter to allow it to be forced off for comparison purposes.
Add ORDER BY clauses to a bunch of regression test queries that will
otherwise produce randomly-ordered output in the new regime.

Revise aggregate functions per earlier discussions in pghackers.

2000-07-17T03:05:41+00:00

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

Update regression tests for ONLY and other recent changes.

2000-06-10T05:19:26+00:00

Update format to add uniform headers on files.

2000-01-05T17:32:29+00:00

aggregate(DISTINCT ...) works, per SQL spec.

1999-12-13T01:27:21+00:00

Note this forces initdb because of change of Aggref node in stored rules.

Reorder tests and move aggregate table data to data/.

1997-04-29T14:29:16+00:00

split out a bunch more tests from misc.source so that the tester knows

1997-04-27T17:40:13+00:00

what's being tested :)