testdb=# create table test (x int);
CREATE TABLE
testdb=# create table test_view as select * from test;
SELECT
testdb=# create rule insert_test as on insert to test_view do instead insert into test values (new.*);
CREATE RULE
testdb=# create rule skip_test as on insert to test_view where x is null do instead nothing;
CREATE RULE
testdb=# insert into test_view values (null);
INSERT 17259 1
testdb=# select * from test;
x
---
(1 row)
According to the last rule the insert should not have happened, right? How come it got ignored?
Thanks!
Dima
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
