"Plugge, Joe R." <jrplu...@west.com> writes: > This is what I have and it seems to work:
> IF OLD.password != NEW.password It'd be better to write "IF OLD.password IS DISTINCT FROM NEW.password". The way with != will not do what you want if one value is null and the other isn't. It's possible this doesn't matter in this particular case (if password can't ever be null in this table), but being careful about nulls is a good habit to cultivate. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql