Re: Equivalent to sql%rowcount or @@rowcount - Mailing list pgsql-sql

On Friday 25 July 2003 07:04, vijaykumar M wrote:
> Hi All! 
> is it possible to get in sql number of rows affected by the sql last insert, 
>
> update or delete statement?? 
>
> for eg, 
>
> oracle ------------- sql%rowcount.
> sqlserver ------------ select @@rowcount.

You can do this sort of thing inside a plpgsql function - see ch 19.5.5 
"Obtaining result status" in the programmers manual.

GET DIAGNOSTICS my_var = ROW_COUNT;

Oh -  and _please_ don't post html-only messages to the list.

--  Richard Huxton Archonet Ltd