Need to know how rules work?

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,

Browse pgsql-general by date

  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