On 6 Jul 2010, at 12:28, Andre Lopes wrote: > Now I need also to add an INSTEAD UPDATE rule and an INSTEAD DELETE rule, but > I have some doubts about it... let me explain... > > Ok, I need to create an INSTEAD UPDATE rule in this view, but I don't know > how to use the clause WHERE in the UPDATE rule. For example the UPDATE could > be done when "WHERE email = 'X' " or "WHERE id = 'Y' ". > > Question: How can I deal with this?
In the WHERE-clause you use the columns from the OLD record that uniquely identify that record. Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:737,4c330b82286211968020069! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
