1 -- $Header: /cvsroot/pgpool/pgpool-II/sample/dist_def_pgbench.sql,v 1.1.1.1 2006/09/08 03:36:17 t-ishii Exp $
3 INSERT INTO pgpool_catalog.dist_def VALUES (
8 ARRAY['bid', 'bbalance', 'filler'],
9 ARRAY['integer', 'integer', 'character(88)'],
10 'pgpool_catalog.dist_def_branches'
13 INSERT INTO pgpool_catalog.dist_def VALUES (
18 ARRAY['tid', 'bid', 'tbalance', 'filler'],
19 ARRAY['integer', 'integer', 'integer', 'character(84)'],
20 'pgpool_catalog.dist_def_tellers'
23 INSERT INTO pgpool_catalog.dist_def VALUES (
28 ARRAY['aid', 'bid', 'abalance', 'filler'],
29 ARRAY['integer', 'integer', 'integer', 'character(84)'],
30 'pgpool_catalog.dist_def_accounts'
33 INSERT INTO pgpool_catalog.dist_def VALUES (
38 ARRAY['tid', 'bid', 'aid', 'delta', 'mtime', 'filler'],
39 ARRAY['integer', 'integer', 'integer', 'integer', 'timestamp without time zone', 'character(22)'],
40 'pgpool_catalog.dist_def_history'
43 CREATE OR REPLACE FUNCTION pgpool_catalog.dist_def_branches(anyelement)
45 SELECT CASE WHEN $1 > 0 AND $1 <= 1 THEN 0
46 WHEN $1 > 1 AND $1 <= 2 THEN 1
51 CREATE OR REPLACE FUNCTION pgpool_catalog.dist_def_tellers(anyelement)
53 SELECT CASE WHEN $1 > 0 AND $1 <= 10 THEN 0
54 WHEN $1 > 10 AND $1 <= 20 THEN 1
59 CREATE OR REPLACE FUNCTION pgpool_catalog.dist_def_accounts(anyelement)
61 SELECT CASE WHEN $1 > 0 AND $1 <= 100000 THEN 0
62 WHEN $1 > 100000 AND $1 <= 200000 THEN 1
67 CREATE OR REPLACE FUNCTION pgpool_catalog.dist_def_history(anyelement)
69 SELECT CASE WHEN $1 > 0 AND $1 <= 10 THEN 0
70 WHEN $1 > 10 AND $1 <= 20 THEN 1