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.farias@digitro.com.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@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>