pr_perm_check.sql

text/plain

Filename: pr_perm_check.sql

Type: text/plain

Part: 0

Message: Re: pgbench - add pseudo-random permutation function

\set a1 pr_perm(0, 1000000000000000, 54321)
\set a2 pr_perm(1999999999999999, 1000000000000000, 54321)
\set a3 pr_perm(2500000000000000, 1000000000000000, 54321)
BEGIN;
DROP TABLE IF EXISTS test;
CREATE TABLE test (id int, data bigint);
INSERT INTO test VALUES(1, :a1);
INSERT INTO test VALUES(2, :a2);
INSERT INTO test VALUES(3, :a3);
END;