Re: Trigger and Trigger function.

On Jun 16, 2005, at 6:56 PM, Matt Iskra wrote:

> CREATE FUNCTION
> oc.upd_last_touch()      <-- syntex error here
> RETURNS TRIGGER AS
> $upd_last_touch$
> BEGIN
>     IF TG_NAME = 'optical_trig' THEN
>         UPDATE optical
>         SET NEW.last_touch = current_timestamp
>         WHERE NEW.id = id;
>     END IF;
> END;
> $upd_last_touch$
> LANGUAGE 'plpgsql' VOLATILE;


I don't think $upd_last_touch$ is a legal dollar quote. It needs to be
alphanumeric characters only (no underscores).


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL