Re: [repost] trigger update time

On Wed, 19 Jun 2002 09:36:34 +0100, Rory Campbell-Lange
<rory@campbell-lange.net> wrote:
>I am trying to update a timestamp value in a related table using
>functions and triggers, but failing miserably!

Rory,

timestamp is not the problem.

>CREATE FUNCTION "fnTU" () RETURNS opaque AS 'BEGIN
>UPDATE a SET tstamp = new.tstamp;
>WHERE new.a_id = id;
>RETURN new;
>END' LANGUAGE 'plpgsql';
    ^
    Insert ; here!

Servus
 Manfred