Re: Trigger question - Mailing list pgsql-novice

From denis@coralindia.com
Subject Re: Trigger question
Date
Msg-id 002801c23787$6ba9d4c0$0232a8c0@coralindia.com
Whole thread Raw
In response to Re: Trigger question  (Josh Jore <josh@greentechnologist.org>)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: AarniRuuhimäki / Megative Tmi / KYMI.com
Date:
Subject: Re: Auto-incrementing field
Next
From: denis@coralindia.com
Date:
Subject: Re: Auto-incrementing field