| From: | "Wm(dot) G(dot) Urquhart" <wgu(at)wurquhart(dot)co(dot)uk> |
|---|---|
| To: | sheetal <sheetal(at)anantinfotech(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Help.. |
| Date: | 2002-05-21 06:38:18 |
| Message-ID: | Pine.LNX.4.44.0205210736490.24870-100000@mailer.wurquhart.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 20 May 2002, sheetal wrote:
> Are there any virtual tables like "inserted" and "deleted" in postgresql to access data which has been inserted or deleted within a transaction like it is there in SQL server?
>
From what I've read in the documentation NEW and OLD are available to you
from within a trigger. The will allow you access to the NEW and OLD data
from a column before and after INSERT / UPDATE.
HTH
--
Regards,
Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wm. G. Urquhart | 2002-05-21 06:46:22 | Re: Foreign key problem in Postgresql-7.2 |
| Previous Message | Stephan Szabo | 2002-05-21 05:57:15 | Re: Foreign key problem in Postgresql-7.2 |