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

Reply via email to