Re: plpgsql question

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. "