Sorry, your right! The example is:
CREATE TABLE customers (
id serial PRIMARY KEY,
name TEXT,
other_data TEXT
);
CREATE TABLE customers_part1(
CHECK (id<10000)
)INHERITS (customers);
CREATE TABLE customers_part2(
CHECK (id>=10000 AND id<20000)
)INHERITS (customers);
CREATE OR REPLACE RULE inserts_customer_part1
AS ON INSERT TO customers
WHERE new.id < 10000
DO INSTEAD INSERT INTO customers_part1 SELECT NEW.*;
CREATE OR REPLACE RULE inserts_customer_part2
AS ON INSERT TO customers
WHERE new.id >= 10000 AND new.id < 20000
DO INSTEAD INSERT INTO customers_part2 SELECT NEW.*;
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
dd=# SELECT * FROM customers;
id | name | other_data
----+---------+------------
3 | XXXXXXx | YYYYYYYYYY
7 | XXXXXXx | YYYYYYYYYY
11 | XXXXXXx | YYYYYYYYYY
15 | XXXXXXx | YYYYYYYYYY
19 | XXXXXXx | YYYYYYYYYY
23 | XXXXXXx | YYYYYYYYYY
(6 rows)
-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html