blob: 6e541341af3f936e49c86bbed2823a7180d5d052 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
--
-- test the random function
--
-- count the number of tuples originally
SELECT count(*) FROM onek;
-- select roughly 1/10 of the tuples
SELECT count(*) FROM onek where oidrand(onek.oid, 10);
-- select again, the count should be different
SELECT count(*) FROM onek where oidrand(onek.oid, 10);
|
