Return number of rows update in query

From: "Shane McEneaney" <shane(at)shadowbox(dot)ie>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Return number of rows update in query
Date: 2000-11-20 15:08:06
Message-ID: 008701c05303$d1f51100$49dc7ac0@gamesnow.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
can anybody tell me how to capture the number of rows updated in
an update query inside a stored procedure? This doesn't work but
hopefully you will see what I mean.

CREATE FUNCTION "test" () RETURNS int AS '
DECLARE
v_number_of_rows int;

BEGIN
select into v_number_of_rows
update carbon_user
set email_confirmed = ''Y''
where email_confirmed = ''Y'';
RETURN v_myvar;
END;
' LANGUAGE 'plpgsql';

Thanks in advance!!!

Shane

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Boettcher 2000-11-20 15:08:26 Re: More stupid questions: prettyprinting of ints??
Previous Message Bruno Boettcher 2000-11-20 14:45:01 More stupid questions: prettyprinting of ints??