Re: pl-pgsql question - Mailing list pgsql-general

From Ron Johnson
Subject Re: pl-pgsql question
Date
Msg-id 1054071303.19268.6.camel@haggis
Whole thread Raw
In response to Re: pl-pgsql question  (Darren Ferguson <darren@crystalballinc.com>)
List pgsql-general
On Thu, 2003-04-24 at 17:02, Darren Ferguson wrote:
> Just the last statement that occurred in that session provided it is an
> update / delete as far as i know
>
> Darren

Should also refer to INSERT INTO ... SELECT ... FROM.

> Dennis Gearon wrote:
>
> > What's the scope of that statement, just the last statement within the
> > same session, all statements within that session, what?
> >
> > Darren Ferguson wrote:
> >
> >> rows INTEGER;
> >>
> >> UPDATE foo SET bar = ''test'';
> >> GET DIAGNOSTICS rows := ROW_COUNT;
> >>
> >> This will return the number of rows actually updated by the system
> >>
> >> HTH
> >> Darren
> >> Vilson farias wrote:
> >>
> >>> Greetings,
> >>>
> >>>  I'm writing some stored procedures using pl-pgsql and I need to
> >>> know how
> >>> many tuples were affected by a update/delete/insert command.
> >>>
> >>>  Let's suppose my script is like this :
> >>>
> >>> CREATE FUNCTION gerachave(INT4) RETURNS INT4 AS'
> >>> DECLARE
> >>>  CAD       ALIAS FOR $1;
> >>> BEGIN
> >>>  novovalor := 0;
> >>>
> >>>  UPDATE table1 SET is_ok = 1 WHERE cod_cad = CAD;
> >>>
> >>>  INSERT INTO cnfg_gerachave VALUES (<quantity of tuples affected by
> >>> UPDATE>);
> >>>
> >>>  RETURN CAD;
> >>> END;
> >>> '
> >>> LANGUAGE 'plpgsql';
> >>>
> >>>
> >>> Is it possible to discovery how many tuples were affected? How can I
> >>> do it?
> >>>
> >>> Thanks in advance.

--
+-----------------------------------------------------------+
| Ron Johnson, Jr.     Home: ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
|                                                           |
| Regarding war zones: "There's nothing sacrosanct about a  |
| hotel with a bunch of journalists in it."                 |
|     Marine Lt. Gen. Bernard E. Trainor (Retired)          |
+-----------------------------------------------------------+


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: How to obtain serial generate when doing an insert?
Next
From: Rory Campbell-Lange
Date:
Subject: Finding line of bug in sql function