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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
