Обсуждение: Row Count

Поиск
Список
Период
Сортировка

Row Count

От
sreejith s
Дата:
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

От
Michael Fuhr
Дата:
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/