Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org> wrote:
>> > you use something simple like (untested):
>> >
>> > | UPDATE cabin_type
>> > | SET id_cabin_type =
>> > | CASE
>> > | WHEN id_cabin_type = id1 THEN
>> > | id2
>> > | ELSE
>> > | id1
>> > | END
>> > | WHERE id_cabin_type IN (id1, id2);
>> Nice, thanks.
> Ah, but this won't work as the UNIQUE PK constraint is in force.
Oh, yes, you're right, I didn't have that premise in mind.
Tim