Re: pl-pgsql question

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
>
>