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-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])