diff options
Diffstat (limited to 'src/test/regress/sql/random.sql')
| -rw-r--r-- | src/test/regress/sql/random.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/sql/random.sql b/src/test/regress/sql/random.sql index 1279a8b0f48..e2333b985f8 100644 --- a/src/test/regress/sql/random.sql +++ b/src/test/regress/sql/random.sql @@ -12,12 +12,12 @@ SELECT count(*) FROM onek; -- have a regression test which can pass/fail -- - thomas 1998-08-17 SELECT count(*) AS random INTO RANDOM_TBL - FROM onek WHERE oidrand(onek.oid, 10); + FROM onek WHERE random() < 1.0/10; -- select again, the count should be different INSERT INTO RANDOM_TBL (random) SELECT count(*) - FROM onek WHERE oidrand(onek.oid, 10); + FROM onek WHERE random() < 1.0/10; -- now test the results for randomness in the correct range SELECT random, count(random) FROM RANDOM_TBL |