Postgres Pro
Downloads
Home   >   mailing lists

Re: Some questions about PLpgSql - Mailing list pgsql-sql

From Tom Lane
Subject Re: Some questions about PLpgSql
Date
Msg-id 14113.984674128@sss.pgh.pa.us
Whole thread Raw
In response to Re: Some questions about PLpgSql  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
> Now, testing how many rows were inserted/updated/deleted ... that I'm
> not sure about.  It would be nice to have a ROWS_AFFECTED returned from
> a data manipulation query in PL/pgSQL, but I don't believe that that has
> been implemented.

It has as of 7.1 --- see GET DIAGNOSTICS foo = ROW_COUNT.
        regards, tom lane

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: List Concatination
Next
From: Tom Lane
Date:
Subject: Re: List Concatination