DECLARE
RowsAffected INTEGER;
BEGIN
-- DO your statement
GET DIAGNOSTICS RowsAffected = ROW_COUNT;
END
On Tuesday 25 November 2003 02:56 pm, Brian Hirt wrote:
> I'm looking to find out how many rows were effected during an update in
> a trigger. I ran across this message by jan talking about this feature
> possibly being added to postgresql 6.5, but I can't find any reference
> to such a feature in the current documentation. Did this ever make it
> into postgresql?
>
> http://archives.postgresql.org/pgsql-sql/1999-02/msg00110.php
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
/* Michael A. Nachbaur <mike@nachbaur.com>
* http://nachbaur.com/pgpkey.asc
*/
"You're very sure of your facts, " he said at last, "I
couldn't trust the thinking of a man who takes the Universe
- if there is one - for granted. "