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

Re: Trigger question

From: Josh Jore <josh(at)greentechnologist(dot)org>
To: denis(at)coralindia(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Trigger question
Date: 2002-07-25 11:54:26
Message-ID: Pine.BSO.4.44.0207250651540.31066-100000@kitten.greentechnologist.org (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: John GuntherDate: 2002-07-25 12:43:59
Subject: Compiling a user C function in 7.2.1
Previous:From: Jerome ChochonDate: 2002-07-25 09:51:02
Subject: Add value in an Array

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