Thanx.... Josh.. and sorry for delay..
I had a bit older document...
Will update those now...
Denis
----- Original Message -----
From: "Josh Jore" <josh@greentechnologist.org>
To: <denis@coralindia.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Thursday, July 25, 2002 5:24 PM
Subject: Re: [NOVICE] Trigger question
> On Thu, 25 Jul 2002 denis@coralindia.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