On Thu, Feb 10, 2005 at 10:31:40AM -0700, Michael Fuhr wrote:
>
> UPDATE tablename SET col1 = <col1value>, col2 = <col2value>, ...
> WHERE keycol = <keyvalue>
> AND (col1 IS DISTINCT FROM <col1value> OR
> col2 IS DISTINCT FROM <col2value> ...)
You could also do this with a trigger. If all columns in the old
and new rows are identical, then the trigger would return NULL to
skip the update for that row.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/