Postgresql: Update problem

Question

I want to do some updates, which logically looks like below -

UPDATE    t1 
SET       (x1, x2) = (SELECT  x1, x2 
                              FROM    t1 
                              WHERE id_1 = 8 
                              AND id_2 =1 
                              AND id_3 = 3)
;

But from the documentation it looks like these types of updates are currently not implemented in Postgresql. Is there any workaround for this problem other than the classic style(By classic I meant set x1 = value1, x2=value2,..... style)?

valodzka · Accepted Answer · 2010-09-05 10:18:19Z

3

You can do it:

UPDATE t1 SET x1 = a.x1, x2 = a.x2 FROM 
   (SELECT x1, x2 FROM t1 WHERE id_1 = 8 AND id_2 = 1 AND id_3 = 3) AS a

Aditional condition may be required:

UPDATE t1 SET x1 = a.x1, x2 = a.x2 FROM 
   (SELECT id, x1, x2 FROM t1 WHERE id_1 = 8 AND id_2 = 1 AND id_3 = 3) AS a 
   WHERE a.id = t1.id

answered Sep 5, 2010 at 10:18

valodzka

5,8554 gold badges41 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql: Update problem

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related