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