pl-pgsql question - Mailing list pgsql-general

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