diff options
Diffstat (limited to 'src/test/regress/sql/aggregates.sql')
| -rw-r--r-- | src/test/regress/sql/aggregates.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/test/regress/sql/aggregates.sql b/src/test/regress/sql/aggregates.sql index 1fc09968072..03ea7de2bbc 100644 --- a/src/test/regress/sql/aggregates.sql +++ b/src/test/regress/sql/aggregates.sql @@ -30,6 +30,12 @@ SELECT max(student.gpa) AS max_3_7 FROM student; SELECT count(four) AS cnt_1000 FROM onek; +SELECT count(DISTINCT four) AS cnt_4 FROM onek; + +select ten, count(*), sum(four) from onek group by ten; + +select ten, count(four), sum(DISTINCT four) from onek group by ten; + SELECT newavg(four) AS avg_1 FROM onek; |