Re: Row Count

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: sreejith s <getsreejith(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-sql-owner(at)postgresql(dot)org
Subject: Re: Row Count
Date: 2005-02-23 16:51:58
Message-ID: 20050223165158.GA27442@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

  • Row Count at 2005-02-23 16:18:29 from sreejith s

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2005-02-23 17:19:57 Re: VIEW / ORDER BY + UNION
Previous Message sreejith s 2005-02-23 16:18:29 Row Count