On Mon, May 24, 2010 at 02:38:39PM +0000, Tim Landscheidt wrote:
> Louis-David Mitterrand <vindex+lists-pgsql-sql@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.