Hi,
Change it to a "BEFORE UPDATE" trigger, and set NEW.updated_date := now();
Otherwise each update produces another update produces another update
-Mark.
[EMAIL PROTECTED] wrote:
Can anybody help me creating a trigger on update trigger with update
statement as below.
This trigger fir
This works. Thanks for response.
- Original Message -
From: "mark reid" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Friday, July 15, 2005 11:16 AM
Subject: Re: [GENERAL] Trigger on Update
Hi,
Change it to a "BEFORE UPDATE" trigger,
On 7/15/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
[snip]
>
> Anybody know what is the syntax I have to use in update statement.
>
>
>
> CREATE TRIGGER "trg_update_note_updated_date" AFTER UPDATE
> ON "property"."note" FOR EACH ROW
> EXECUTE PROCEDURE
> "property"."update_not
Anybody know what is the syntax I have to use in update statement.
Try using now() instead of CURRENT_DATE.
CREATE TRIGGER "trg_update_note_updated_date" AFTER UPDATE
ON "property"."note" FOR EACH ROW
EXECUTE PROCEDURE "property"."update_note_updated_date_trg"();
CREATE OR REPLACE
Can anybody help me creating a trigger on update
trigger with update statement as below.
This trigger fires after update on a table called
note to update the updated_date field.
But when the table is updated the trigger is firing
recursively.
Anybody know what is the syntax I have to
