Postgres Pro
Downloads
Home   >   mailing lists

Thread: Row Count

Row Count

From
sreejith s
Date:
Hai friends,
How get Row count in a plpgsql fuction after executing update or
delete query to determine no. of rows affected.

Sreejith

Re: Row Count

From
Michael Fuhr
Date:
On Wed, Feb 23, 2005 at 09:48:29PM +0530, sreejith s wrote:

> How get Row count in a plpgsql fuction after executing update or
> delete query to determine no. of rows affected.

See "Obtaining the Result Status" in the PL/pgSQL documentation.

http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/