I've already reported this to the webpage, but I got a fail on the random
test:
random ... failed (ignored)
This is on a stock RedHat 7.0 kernel box with the SMP kernel (but running a
single processor):
[pjm3@localhost regress]$ less regression.diffs
*** ./expected/random.out Thu Jan 6 06:40:54 2000
--- ./results/random.out Tue Mar 27 15:07:16 2001
***************
*** 25,31 ****
GROUP BY random HAVING count(random) > 1;
random | count
--------+-------
! (0 rows)
SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
--- 25,32 ----
GROUP BY random HAVING count(random) > 1;
random | count
--------+-------
! 99 | 2
! (1 row)
SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
======================================================================
Regards,
Phil
+----------------------------------+
| Phil Mayers, Network Support |
| Centre for Computing Services |
| Imperial College |
+----------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
