empire-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Weidele <daniel.weid...@gmail.com>
Subject Support for Update of Composite Primary Key
Date Mon, 14 Nov 2016 17:08:28 GMT
Hi,

I am wondering if there is some support for a query in this style:

UPDATE  t
SET     value = 99
FROM    (
        VALUES
        ('xxx', 'yyy'),
        ('zzz', 'ttt')
        ) v (in_x, in_y)
JOIN    mytable t
ON      t.x = in_x
        AND t.y = in_y

This *batch* updates particular rows of a table (e.g. with composite
primary key), where the row identifiers are given input.

I am curious about your thoughts on this!

Cheers,
Daniel

Mime
View raw message