diff options
Diffstat (limited to 'src/test/regress/expected/aggregates.out')
| -rw-r--r-- | src/test/regress/expected/aggregates.out | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index 82ede655aa9..c4ea86ff050 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -1388,6 +1388,12 @@ select min(unique1) filter (where unique1 > 100) from tenk1; 101 (1 row) +select sum(1/ten) filter (where ten > 0) from tenk1; + sum +------ + 1000 +(1 row) + select ten, sum(distinct four) filter (where four::text ~ '123') from onek a group by ten; ten | sum |