> > In my particular situation the case I care about is when the result > of an UPDATE is two identical rows. All I really want is a DISTINCT > option. > > Assuming I am following correctly what you want is that the result of > an UPDATE not be two identical rows.
Correct. In practice I don't care whether the action is IGNORE or REPLACE (in Sqlite terms), the outcome is the same. Obviously two different records that share the same primary key is a bad thing and worth an error. Two identical records is just boring. Regards David M Bennett FACS Andl - A New Database Language - andl.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
