Anna Dorofiyenko wrote:
> Hello, list.
>
> How can I get in PL/pgSQL number of rows affected by insert/update?
>
>
>
> I'm looking to do something like:
>
> insert into...
>
> If rowcount>0
>
> then ...
>
See section 23.5.5 at:
http://www.postgresql.org/idocs/index.php?plpgsql-statements.html
Here's the part you want:
23.5.5. Obtaining result status
GET DIAGNOSTICS variable = item [ , ... ] ;
This command allows retrieval of system status indicators. Each item is
a keyword identifying a state value to be assigned to the specified
variable (which should be of the right data type to receive it). The
currently available status items are ROW_COUNT, the number of rows
processed by the last SQL query sent down to the SQL engine; and
RESULT_OID, the Oid of the last row inserted by the most recent SQL
query. Note that RESULT_OID is only useful after an INSERT query.
HTH,
Joe