On Mon, May 24, 2010 at 02:38:39PM +0000, Tim Landscheidt wrote: > Louis-David Mitterrand <vindex+lists-pgsql-...@apartia.org> wrote: > > What does "are not properly updated" mean? Anyhow, why don't
Hi, I did follow-up on my own post: the problem was elsewhere. > 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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
