Re: SGI Port of Postgresql 6.4 snapshot of 09/28/98

From: Robert Bruccoleri <bruc(at)pluto(dot)njcc(dot)com>
To: bruc(at)pluto(dot)njcc(dot)com (bruc)
Cc: pgsql-hackers(at)hub(dot)org, scrappy(at)hub(dot)org, maillist(at)candle(dot)pha(dot)pa(dot)us
Subject: Re: SGI Port of Postgresql 6.4 snapshot of 09/28/98
Date: 1998-09-29 15:01:35
Message-ID: 199809291501.LAA15186@pluto.njcc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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(at)acm(dot)org | Rutgers University |
| URL: http://www.cabm.rutgers.edu/~bruc | 679 Hoes Lane |
| | Piscataway, NJ 08854-5638 |
+------------------------------------------+------------------------------+

Browse pgsql-hackers by date

  From Date Subject
Next Message David Hartwig 1998-09-29 16:27:34 Re: [HACKERS] PL/pgSQL in template1?
Previous Message Jackson, DeJuan 1998-09-29 14:53:45 SQL92