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 [EMAIL PROTECTED] -- /* Michael A. Nachbaur <[EMAIL PROTECTED]> * 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. " ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings