Re: Functions and Triggers

CREATE FUNCTION lastupdated() RETURNS opaque AS '
begin new.last_updated := CURRENT_TIMESTAMP; return new;
end;
' LANGUAGE 'plpgsql';

CREATE TRIGGER trigname BEFORE INSERT OR UPDATE on tblname FOR EACH ROW EXECUTE PROCEDURE lastupdated();

Note: you could use now() instead of CURRENT_TIMESTAMP

Note2: on a BEFORE trigger you must return new or old.  If you return null
the statement will be aborted. (?)

-Cedar


On Mon, 26 Mar 2001, Norbert Schollum wrote:

> Hello there!
> 
> here is what i want to realize:
> 
> a trigger, that puts a now() in the last_updated field, on any update of
> that table.
> 
> i read the manual but i wasnt able to make a working function.
> what is the return value here? is there any or is it void?
> 
> has somebody a example for me that is similary to my problem?
> 
> thank you alot!
> 
> Greetings
> Norbert
> 
> 
> --
> 
> Norbert Schollum
> -----------------------------------------------
> equinux Aktiengesellschaft
> Informationstechnologien
> Gabelsbergerstr. 30
> 80333 München - Germany
> Tel. 089/520465-0
> Fax. 089/520465-299
> mailto:schollum@equinux.de
> http://www.equinux.de
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>