Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help..

Help..

From
"sheetal"
Date:
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?

Re: Help..

From
Neil Conway
Date:
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
deletedwithin a transaction like it is there in SQL server?  

Not AFAIK.

Cheers,

Neil

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

Re: Help..

From
"Wm. G. Urquhart"
Date:
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
deletedwithin 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

Re: Help..

From
"Marin Dimitrov"
Date:
 
----- Original Message -----
From: sheetal
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. "