Re: [repost] trigger update time - Mailing list pgsql-novice

Rory Campbell-Lange <rory@campbell-lange.net> writes:
> CREATE FUNCTION "fnTU" () RETURNS opaque AS 'BEGIN
> UPDATE a SET tstamp = new.tstamp;
                                  ^ remove this semicolon
> WHERE new.a_id = id;
> RETURN new;
> END' LANGUAGE 'plpgsql';

Depending on your PG version you might also need to add a semicolon
after END.

            regards, tom lane