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