On Thu, 25 Jul 2002 denis(at)coralindia(dot)com wrote:
> Hi all,
> I have written a trigger in which i am updating few rows of another table
> (AFTER insert in MAIN table).
So you read the nicely written docs?
> Is there any variable available like we have SQL%COUNT in Oracle ??? Does
> Postgres creates any INTERNAL CURSOR like Oracle ??
Sure, this is *right* in the spot in the manual about coding triggers
(which you already read once). It's something like
GET DIAGNOSTICS rc = ROW_COUNT;
or such. But verify that by reading the man page.
Joshua b. Jore ; http://www.greentechnologist.org
In response to
pgsql-novice by date
|Next:||From: John Gunther||Date: 2002-07-25 12:43:59|
|Subject: Compiling a user C function in 7.2.1|
|Previous:||From: Jerome Chochon||Date: 2002-07-25 09:51:02|
|Subject: Add value in an Array|