Support for Update of Composite Primary Key

[Daniel Weidele]

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