pl-pgsql question
От | Vilson farias |
---|---|
Тема | pl-pgsql question |
Дата | |
Msg-id | 020501c30a9b$083697b0$98a0a8c0@dgtac обсуждение исходный текст |
Ответы |
Re: pl-pgsql question
|
Список | 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
В списке pgsql-general по дате отправления: