Re: Trigger on Update - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Trigger on Update
Date
Msg-id 42D7FC4F.5030000@commandprompt.com
Whole thread Raw
In response to Trigger on Update  (<sunithab@travelpost.com>)
List pgsql-general
> 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 FUNCTION "property"."update_note_updated_date_trg" ()
> RETURNS trigger AS
> $body$
> begin
>   /* New function body */
>        UPDATE property.note SET updated_date=CURRENT_DATE
>        WHERE note_id = NEW. note_id;
>     return null;
> end;
> $body$
> LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Postgres for Fedora Core 2 OS ****************
Next
From: Mike Rylander
Date:
Subject: Re: Trigger on Update