> >
> > hello novice list,
> > can somebody show me where my mistake is with this trigger.
> > everything is fine, but they don't fire......
> >
> > ---------------------------------------------------------------------
> >
> > CREATE FUNCTION qp_question_moddate() RETURNS OPAQUE
> > AS '
> > BEGIN
> >
> > NEW.moddate := current_date;
> > RETURN NEW;
> > END;
> > ' LANGUAGE 'plpgsql';
> >
> > create trigger qp_question_moddate_update after update on qp_question
> > for each row execute procedure qp_question_moddate();
>
> After triggers are too late for modifying NEW (since the record is already
> created or changed), you'd need to make it a before trigger.
great, thank you
--
joe speigle
www.sirfsup.com