diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-11-21 00:45:18 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-11-21 00:45:18 +0000 |
| commit | 9b3bcdd41fc614f4be293927548c5acc11f666b2 (patch) | |
| tree | cf75491903935a762fac7bba6fd64ce45f75c016 | |
| parent | f25d3a504415c1b8810428e08a51fb6a41b70db4 (diff) | |
| download | postgresql-9b3bcdd41fc614f4be293927548c5acc11f666b2.tar.gz postgresql-9b3bcdd41fc614f4be293927548c5acc11f666b2.zip | |
This locale-specific variant file seems not to have been updated
when a test was added to select_having.sql back in June.
| -rw-r--r-- | src/test/regress/expected/select_having_1.out | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/src/test/regress/expected/select_having_1.out b/src/test/regress/expected/select_having_1.out index b53f4a7f11a..62ec6a96b03 100644 --- a/src/test/regress/expected/select_having_1.out +++ b/src/test/regress/expected/select_having_1.out @@ -21,6 +21,15 @@ SELECT b, c FROM test_having 3 | bbbb (2 rows) +-- HAVING is equivalent to WHERE in this case +SELECT b, c FROM test_having + GROUP BY b, c HAVING b = 3; + b | c +---+---------- + 3 | BBBB + 3 | bbbb +(2 rows) + SELECT lower(c), count(c) FROM test_having GROUP BY lower(c) HAVING count(*) > 2 OR min(a) = max(a); lower | count |