| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | right RULE? |
| Date: | 2000-08-17 11:17:50 |
| Message-ID: | Pine.LNX.3.96.1000817131626.31414G-100000@ara.zf.jcu.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
test=# CREATE TABLE rrr (id int);
CREATE
test=# CREATE RULE rrr_r AS ON DELETE TO rrr
DO INSTEAD SELECT 'Not Delete';
CREATE
test=# INSERT INTO rrr VALUES (1);
INSERT 161557 1
test=# INSERT INTO rrr VALUES (2);
INSERT 161558 1
test=# DELETE FROM rrr;
?column?
------------
Not Delete
(1 row)
Well, all is right. I add 'WHERE OLD.id = 2' to rule definition
and:
test=# DROP RULE rrr_r;
DROP
test=# CREATE RULE rrr_r AS ON DELETE TO rrr WHERE OLD.id = 2
DO INSTEAD SELECT 'Not Delete';
CREATE
test=# DELETE FROM rrr WHERE id = 2;
DELETE 0
#
The RULE works (nothing is deleted), but where is a output from SELECT?
It's in 7.1 and 6.5 too. Is it right?
Karel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Horák Daniel | 2000-08-17 12:00:44 | RE: [HACKERS] Linux/Alpha Regression Test Patch |
| Previous Message | Karel Zak | 2000-08-17 10:47:43 | Re: Bug in to_timestamp() |