Re: UPDATE OR REPLACE?

> > 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
recordsis just boring. 

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org