| From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
|---|---|
| To: | betty <liongliong(at)telkom(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: trigger after with cursor |
| Date: | 2003-02-18 20:21:44 |
| Message-ID: | 20030218202144.42701.qmail@web20802.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
--- betty <liongliong(at)telkom(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2003-02-18 20:47:44 | Re: Drop temporary table only if it exists |
| Previous Message | Jan Wieck | 2003-02-18 20:20:26 | Re: Trigger that will execute external program |