Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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    |
+------------------------------------------+------------------------------+

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group