From: | "Dan Langille" <dan(at)langille(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable> |
Date: | 2001-01-18 07:15:39 |
Message-ID: | 200101180715.UAA14446@ducky.nz.freebsd.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Does anyone know if this feature exists? If so, what version or where
can a patch be obtained?
Thanks
------- Forwarded message follows -------
Date sent: Mon, 15 Jan 2001 08:44:46 +0100
From: "J.H.M. Dassen (Ray)" <jdassen(at)cistron-office(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: getting number of rows updated within a procedure
On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote:
> I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a
> question: At various times, it does UPDATEs. Is there a way to tell if
> the UPDATE actually affected any rows or not? I couldn't see how to get
> UPDATE to return anything.
Quoting a recent message by Jan Wieck <janwieck(at)Yahoo(dot)com>:
:Do a
:
: GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable>;
:
:directly after an INSERT, UPDATE or DELETE statement and you'll know
:how many rows have been hit.
:
:Also you can get the OID of an inserted row with
:
: GET DIAGNOSTICS SELECT RESULT INTO <int4_variable>;
HTH,
Ray
--
"The software `wizard' is the single greatest obstacle to computer literacy
since the Mac."
http://www.osopinion.com/Opinions/MichaelKellen/MichaelKellen1.html
------- End of forwarded message -------
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/
FreshPorts - http://freshports.org/
NZ Broadband - http://unixathome.org/broadband/
From | Date | Subject | |
---|---|---|---|
Next Message | J.H.M. Dassen (Ray) | 2001-01-18 08:05:56 | Re: GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable> |
Previous Message | Tom Lane | 2001-01-18 07:14:07 | Re: Using max() MUCH slower in v7.1 |
From | Date | Subject | |
---|---|---|---|
Next Message | J.H.M. Dassen (Ray) | 2001-01-18 08:05:56 | Re: GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable> |
Previous Message | Tom Lane | 2001-01-18 06:35:38 | Datetime regression tests are all failing |