Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT?

From: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>
To: pgsql-general(at)postgresql(dot)org
Subject: Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT?
Date: 2001-08-30 08:05:46
Message-ID: 20010830080546.30326.qmail@sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexey Borzov 2001-08-30 08:19:56 pg7.1 release date
Previous Message Alexey Borzov 2001-08-30 07:55:30 Re[2]: RFC: PostgreSQL and MySQL comparison.