You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@empire-db.apache.org by Daniel Weidele <da...@gmail.com> on 2016/11/14 17:08:28 UTC

Support for Update of Composite Primary Key

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