diff options
Diffstat (limited to 'src/test/regress/sql/select_having.sql')
| -rw-r--r-- | src/test/regress/sql/select_having.sql | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/src/test/regress/sql/select_having.sql b/src/test/regress/sql/select_having.sql index 28b22d9859..44b0329ee5 100644 --- a/src/test/regress/sql/select_having.sql +++ b/src/test/regress/sql/select_having.sql @@ -18,10 +18,6 @@ INSERT INTO test_having VALUES (9, 4, 'CCCC', 'j'); SELECT b, c FROM test_having GROUP BY b, c HAVING count(*) = 1; --- HAVING is equivalent to WHERE in this case -SELECT b, c FROM test_having - GROUP BY b, c HAVING b = 3; - SELECT lower(c), count(c) FROM test_having GROUP BY lower(c) HAVING count(*) > 2 OR min(a) = max(a); |