> Gentlemen:
The test of the Irix port of PostgreSQL running with default
optimization passes all the regression tests the same as before
except that the random number test is now different. The new output is
included below. It appears to be OK, but I would like confirmation.
Thanks.
=============================random.out=================================
QUERY: SELECT count(*) FROM onek;
count
-----
1000
(1 row)
QUERY: SELECT count(*) AS random INTO RANDOM_TBL
FROM onek WHERE oidrand(onek.oid, 10);
QUERY: INSERT INTO RANDOM_TBL (random)
SELECT count(*)
FROM onek WHERE oidrand(onek.oid, 10);
QUERY: SELECT random, count(random) FROM RANDOM_TBL
GROUP BY random HAVING count(random) > 1;
random|count
------+-----
(0 rows)
QUERY: SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
random
------
74
(1 row)
+------------------------------------------+------------------------------+
| Robert E. Bruccoleri, Ph.D. | Associate Research Professor |
| phone: 732 235 5796 | Center for Advanced |
| Fax: 732 235 4850 | Biotechnology and Medicine |
| email: bruc@acm.org | Rutgers University |
| URL: http://www.cabm.rutgers.edu/~bruc | 679 Hoes Lane |
| | Piscataway, NJ 08854-5638 |
+------------------------------------------+------------------------------+