> > I have tried the following: -
> >
> > CREATE FUNCTION set_item_last_updated () RETURNS OPAQUE AS '
> > BEGIN
> > UPDATE item SET last_updated = now();
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> > RETURN OLD;
> > END;' LANGUAGE 'plpgsql';
Even better I guess, if you are running 7.1 or greater, use
CURRENT_TIMESTAMP instead of now()?
Chris