prp_test_3.sql

application/x-sql

Filename: prp_test_3.sql

Type: application/x-sql

Part: 5

Message: pgbench - add pseudo-random permutation function

\set seed random(1, 1000000000000)
\set i0 pr_perm(0, 3, :seed)
\set i1 pr_perm(1, 3, :seed)
\set i2 pr_perm(2, 3, :seed)
INSERT INTO perm_count AS pc (perm)
  VALUES (:i0 + :i1 * 10 + :i2*100)
  ON CONFLICT (perm) DO UPDATE SET cnt = pc.cnt+1;