Re: [HACKERS] bug (?) with RULEs with WHERE

Kovacs Zoltan [EMAIL PROTECTED] writes: foo=# CREATE TABLE a(foo integer); CREATE foo=# CREATE TABLE b(foo integer); CREATE foo=# CREATE VIEW c AS SELECT foo FROM a; CREATE foo=# CREATE RULE d AS ON INSERT TO c WHERE new.foo=5 DO INSTEAD SELECT foo FROM b; CREATE foo=# INSERT INTO c

[HACKERS] bug (?) with RULEs with WHERE

I cannot use RULEs with WHERE clauses. What's wrong? Is this a bug? I also had this problem with 7.1.1. The documentation says this should work. foo=# SELECT version(); version - PostgreSQL 7.1.3