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