From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | dan(at)langille(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable> |
Date: | 2001-01-18 18:01:13 |
Message-ID: | 200101181801.NAA24170@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
It is in 7.1beta, and is not documented yet.
it> 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/
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Aland | 2001-01-18 18:04:30 | Dropping a column |
Previous Message | Jeff Self | 2001-01-18 17:57:47 | How do I import table information? |
From | Date | Subject | |
---|---|---|---|
Next Message | wenjin.zheng | 2001-01-18 18:01:50 | Gateway |
Previous Message | Patrick Welche | 2001-01-18 15:34:22 | Re: Autoconf version discrepancies |