diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-12-15 17:57:48 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-12-15 17:57:48 +0000 |
| commit | 34d26872ed816b299eef2fa4240d55316697f42d (patch) | |
| tree | d7373e29b365c151702c44325f0f5cc9dcc3e17c /src/test/regress/output/misc.source | |
| parent | 6a6efb964092902bf53965649c3ed78b1868b37e (diff) | |
| download | postgresql-34d26872ed816b299eef2fa4240d55316697f42d.tar.gz | |
Support ORDER BY within aggregate function calls, at long last providing a
non-kluge method for controlling the order in which values are fed to an
aggregate function. At the same time eliminate the old implementation
restriction that DISTINCT was only supported for single-argument aggregates.
Possibly release-notable behavioral change: formerly, agg(DISTINCT x)
dropped null values of x unconditionally. Now, it does so only if the
agg transition function is strict; otherwise nulls are treated as DISTINCT
normally would, ie, you get one copy.
Andrew Gierth, reviewed by Hitoshi Harada
Diffstat (limited to 'src/test/regress/output/misc.source')
| -rw-r--r-- | src/test/regress/output/misc.source | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/test/regress/output/misc.source b/src/test/regress/output/misc.source index 91e0d2b04d..0effa4b853 100644 --- a/src/test/regress/output/misc.source +++ b/src/test/regress/output/misc.source @@ -571,6 +571,7 @@ SELECT user_relns() AS user_relns a_star abstime_tbl aggtest + aggtype array_index_op_test array_op_test arrtest @@ -668,7 +669,7 @@ SELECT user_relns() AS user_relns toyemp varchar_tbl xacttest -(101 rows) +(102 rows) SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))); name |