Hello,
In the documentation on the following page:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=regress-evaluation.html
in section 13.3.6, you state that benign row ordering differences should be reported. I got the following output,
which I believe is a bogus failure:
*** ./expected/select_having_1.out Wed Nov 20 19:45:18 2002
--- ./results/select_having.out Wed Feb 12 15:10:08 2003
***************
*** 26,33 ****
GROUP BY b, c HAVING b = 3;
b | c
---+----------
- 3 | BBBB
3 | bbbb
(2 rows)
SELECT lower(c), count(c) FROM test_having
--- 26,33 ----
GROUP BY b, c HAVING b = 3;
b | c
---+----------
3 | bbbb
+ 3 | BBBB
(2 rows)
SELECT lower(c), count(c) FROM test_having
I am running Linux 7.2 and Postgresql 7.3. Please don't hesitate to contact me at the following address
with questions/problems:
Scott.wilson@cubic.com