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-stat
>
> Dear SQL and plPgSQL gurus, I seek for your wisdom.
>
> I have a variable assignment via SELECT INTO in my function, and I want
> to separate 3 cases:
> 1) no rows found;
> 2) one row found;
> 3) many rows found (ambiguous select).
>
> The first case is simple, I use FOUND variable for it.
>
