Re: Updating

On Monday 17 March 2008 4:54 am, Daniel Verite wrote:
> Adrian Klaver wrote:
> > CREATE FUNCTION foo() RETURNS trigger AS
> > $Body$
> > BEGIN
> > IF NEW.colname != OLD.colname THEN
> > ..."Do something"..;
> > RETURN whatever;
> > ELSE
> > RETURN NEW:
> > END IF;
> > END;
> > $Body$ LANGUAGE plpgsql;
>
> Beware that the "Do something" code path will not be taken when the
> column goes from NULL to non-NULL or non-NULL to NULL.
>
> In the general case where the column is nullable, better use "IS
> DISTINCT FROM" instead of inequality:
> IF NEW.colname IS DISTINCT FROM OLD.colname
>
> Best regards,
> --
> Daniel
> PostgreSQL-powered mail user agent and storage:
> http://www.manitou-mail.org

Thanks for the heads up. This is a case I usually only remember when I start
testing the function.
--
Adrian Klaver
aklaver(at)comcast(dot)net