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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
