PostgreSQL, Help..

Help..

Author	Message
Neil Conw #1 / 3	Help.. On Mon, 20 May 2002 14:44:06 -0700 Quote: > 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 -- PGP Key ID: DB3C29FC ---------------------------(end of broadcast)---------------------------
Sat, 06 Nov 2004 09:40:04 GMT

Wm. G. Urquhar #2 / 3	Help.. Quote: > 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 ---------------------------(end of broadcast)---------------------------
Sat, 06 Nov 2004 14:24:31 GMT

Marin Dimitro #3 / 3	Help.. This is a multi-part message in MIME format. ------=_NextPart_000_005C_01C200E3.594D4E90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Quote: ----- Original Message -----=20 From: sheetal=20 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?=20 ---------------------------------------------------------------------------= --- 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=20 you must choose a new path, do not bring old experiences with you.=20 Those who strike out afresh, but who attempt to retain a little of the=20 old life, end up torn apart by their own memories. " ------=_NextPart_000_005C_01C200E3.594D4E90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"> <META content=3D"MSHTML 5.50.4915.500" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2></FONT> </DIV> <BLOCKQUOTE dir=3Dltr=20 style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LE= FT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>Fro= m:</B>=20 resql.org=20 </A>=20 </DIV> <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, May 21, 2002 00:44<= /DIV> <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [GENERAL] Help..</DIV> <DIV><FONT size=3D2></FONT><BR></DIV> <DIV><FONT face=3DArial size=3D2>Are there any virtual tables like "inser= ted" and=20 "deleted" in postgresql to access data which has been inserted or deleted= =20 within a transaction like it is there in SQL server?=20 <HR> </FONT></DIV></BLOCKQUOTE> <DIV><FONT size=3D2>u should be able to achieve the same effect by=20 using triggers</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>hth,</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>    Marin</FONT></DIV> <DIV> <DIV><FONT size=3D2></FONT><BR>----<BR>"...what you brought from your past,= is of=20 no use in your present. When <BR>you must choose a new path, do not bring o= ld=20 experiences with you. <BR>Those who strike out afresh, but who attempt to r= etain=20 a little of the <BR>old life, end up torn apart by their own memories. "</D= IV> <DIV><FONT size=3D2></FONT> </DIV></DIV></BODY></HTML> ------=_NextPart_000_005C_01C200E3.594D4E90--
Sat, 06 Nov 2004 21:27:19 GMT

Page 1 of 1

[ 3 post ]