On Wed, 19 Jun 2002 09:36:34 +0100, Rory Campbell-Lange
<rory(at)campbell-lange(dot)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