Re: trigger after with cursor - Mailing list pgsql-sql

From Jeff Eckermann
Subject Re: trigger after with cursor
Date
Msg-id 20030218202144.42701.qmail@web20802.mail.yahoo.com
Whole thread Raw
In response to Re: trigger after with cursor  ("betty" <liongliong@telkom.net>)
List pgsql-sql
--- betty <liongliong@telkom.net> wrote:
> I mean are there any solution for Using  "Update"
> statement
> inside 'trigger after update'..??? for update it's
> table self.
> rather than using "CURSOR"
> 
No.  The only values you can change are those in the
NEW row, by assigning values to them in your
procedure.

I could not tell from your code just what you are
trying to do: if you could tell us more about that,
perhaps someone can advise you.

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Drop temporary table only if it exists
Next
From: Jan Wieck
Date:
Subject: Re: Trigger that will execute external program