Re: pl-pgsql question

Just the last statement that occurred in that session provided it is an
update / delete as far as i know

Darren

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.
>>>
>>>
>>>
>>> ----------------------------------------------------------------------------
>>> ----
>>> José Vilson de Mello de Farias
>>> Software Engineer
>>>
>>> Dígitro Tecnologia Ltda - www.digitro.com.br
>>> APC - Customer Oriented Applications
>>> E-mail: vilson(dot)farias(at)digitro(dot)com(dot)br
>>> Tel.: +55 48 281 7158
>>> ICQ 11866179
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 3: if posting/reading through Usenet, please send an appropriate
>>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>> message can get through to the mailing list cleanly
>>>
>>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)