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
Hai friends,
How get Row count in a plpgsql fuction after executing update or
delete query to determine no. of rows affected.
Sreejith
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
>
> 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.
>
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.
But how about the thir
