On 06/01/12 16:33, David Johnston wrote:
In 9.1 you could use and updatable CTE and in the main query perform
and return a count. I would think plpgsql would be the better option
though.
For the SQL option, it would be this (9.1 only though - I think David's
right there).
CREATE FUNCTION f1() RETURNS int AS $$
WITH rows AS (
UPDATE t1 SET ... WHERE ... RETURNING 1
)
SELECT count(*)::int FROM rows
$$ LANGUAGE SQL;
Unfortunately you can't do UPDATE ... RETURNING count(*) directly so you
need to go through this business with the CTE (WITH clause).
Oh - the cast to int is because count() returns bigint.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
