Re: pl-pgsql question
От | Ron Johnson |
---|---|
Тема | Re: pl-pgsql question |
Дата | |
Msg-id | 1054071303.19268.6.camel@haggis обсуждение исходный текст |
Ответ на | Re: pl-pgsql question (Darren Ferguson <darren@crystalballinc.com>) |
Список | pgsql-general |
On Thu, 2003-04-24 at 17:02, Darren Ferguson wrote: > Just the last statement that occurred in that session provided it is an > update / delete as far as i know > > Darren Should also refer to INSERT INTO ... SELECT ... FROM. > 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. -- +-----------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | Regarding war zones: "There's nothing sacrosanct about a | | hotel with a bunch of journalists in it." | | Marine Lt. Gen. Bernard E. Trainor (Retired) | +-----------------------------------------------------------+
В списке pgsql-general по дате отправления: