Skip site navigation (1) Skip section navigation (2)

Re: Trigger question

From: denis(at)coralindia(dot)com
To: "Josh Jore" <josh(at)greentechnologist(dot)org>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Trigger question
Date: 2002-07-30 05:10:27
Message-ID: 002801c23787$6ba9d4c0$0232a8c0@coralindia.com (view raw or flat)
Thread:
Lists: 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(at)greentechnologist(dot)org>
To: <denis(at)coralindia(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, July 25, 2002 5:24 PM
Subject: Re: [NOVICE] Trigger question


> 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: denisDate: 2002-07-30 05:22:34
Subject: Re: Auto-incrementing field
Previous:From: Aarni Ruuhimäki / Megative Tmi / KYMI.comDate: 2002-07-29 16:53:41
Subject: Re: Auto-incrementing field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group