| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
| Cc: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Rules in views, how to? |
| Date: | 2010-07-06 10:54:49 |
| Message-ID: | B1A9D663-3D84-496F-8B6D-B89CAAFA3DAB@solfertje.student.utwente.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Lopes | 2010-07-06 11:03:38 | Re: Rules in views, how to? |
| Previous Message | Andre Lopes | 2010-07-06 10:39:02 | Rules in views, how to? |