Jeff Janes wrote:
> I want to update some data in unique column. Some of the updates
> would conflict if applied to eligible rows, and for now I want to
> skip those updates, applying only one of a set of conflicting
> ones.
>
> create table foo (x text unique);
> insert into foo values ('aac'),
I want to update some data in unique column. Some of the updates would
conflict if applied to eligible rows, and for now I want to skip those
updates, applying only one of a set of conflicting ones. I can use a not
exists subquery to detect when the new value would conflict with an
existing one,
