From 9b3bcdd41fc614f4be293927548c5acc11f666b2 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 21 Nov 2002 00:45:18 +0000 Subject: [PATCH] This locale-specific variant file seems not to have been updated when a test was added to select_having.sql back in June. --- src/test/regress/expected/select_having_1.out | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/src/test/regress/expected/select_having_1.out b/src/test/regress/expected/select_having_1.out index b53f4a7f11..62ec6a96b0 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 -- 2.50.0