From: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Need to know how rules work? |
Date: | 2010-02-17 01:55:50 |
Message-ID: | 18f98e681002161755n6f2d0fb9ufff974079e7cc3fa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have created this table:
[quote]
CREATE OR REPLACE VIEW "am_newsletter_distritos" AS
select * from atm_newsletter_distritos;
CREATE OR REPLACE RULE "ins_am_newsletter_distritos" AS
ON INSERT TO "am_newsletter_distritos"
DO INSTEAD
(insert into atm_newsletter_distritos (email, id_distrito) values
(new.email, new.id_distrito));
CREATE OR REPLACE RULE "upd_am_newsletter_distritos" AS
ON DELETE TO "am_newsletter_distritos"
DO INSTEAD
(delete from atm_newsletter_distritos where email = old.email);
[/quote]
With these delete rule I can delete using on WHERE clause other field that
"email"?
Best Regards,
From | Date | Subject | |
---|---|---|---|
Next Message | Megha | 2010-02-17 03:02:27 | pgpool error, pid not found! |
Previous Message | Daniel Verite | 2010-02-17 01:50:36 | Re: No tables in postgres and template db |