Help.. 
Author Message
 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
 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
 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>&nbsp;</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&nbsp;triggers</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>hth,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>&nbsp;&nbsp;&nbsp; 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>&nbsp;</DIV></DIV></BODY></HTML>

------=_NextPart_000_005C_01C200E3.594D4E90--



Sat, 06 Nov 2004 21:27:19 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. help,help,help,help,help,help,help,help,help,help,help,help,help,

2. Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,

3. help help help help help help help help help

4. SQL To ORACLE Help Help Help Help Help

5. query:HELP! HELP HELP HELP HELP

6. Help help help help

7. HELP HELP HELP HELP!

8. HELP HELP HELP HELP

9. Help Help Help -- long operations

10. HELP HELP HELP!!!!

11. SQL Selection - HELP HELP HELP

12. HELP HELP HELP


 
Powered by phpBB® Forum Software