testlibpq2.sql

来自「PostgreSQL7.4.6 for Linux」· SQL 代码 · 共 7 行

CREATE TABLE TBL1 (i int4);

CREATE TABLE TBL2 (i int4);

CREATE RULE r1 AS ON INSERT TO TBL1 DO
(INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2);