Postgres Pro
Downloads
Home   >   mailing lists

Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT? - Mailing list pgsql-general

From Dr. Evil
Subject Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT?
Date
Msg-id 20010830080546.30326.qmail@sidereal.kz
Whole thread Raw
In response to Finding the number of rows affected by UPDATE or INSERT?  ("Dr. Evil" <drevil@sidereal.kz>)
List pgsql-general
Tree view 
I found out how to do it:

In pl/pgsql:

INT nr;

UPDATE ....
GET DIAGNOSTICS SELECT PROCESSED INTO nr;

will put the number of rows into nr.  It's a very useful feature to
have this in PG7.1.

pgsql-general by date:

Previous
From: Alexey Borzov
Date:
Subject: Re[2]: RFC: PostgreSQL and MySQL comparison.
Next
From: Alexey Borzov
Date:
Subject: pg7.1 release date