Help..

On Mon, 20 May 2002 14:44:06 -0700
"sheetal" <sheetal@anantinfotech.com> 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?

Not AFAIK.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

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

----- Original Message -----
From: sheetal
To: pgsql-general@postgresql.org
Sent: Tuesday, May 21, 2002 00:44
Subject: [GENERAL] Help..

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?
------------------------------------------------------------------------------

u should be able to achieve the same effect by using triggers

hth,

Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "