Hello,
I am facing the following problem, nothing tough, I guess (hope)..think it should be some syntactical problem: 1. When trying to update two columns UPDATE myFirstTable SET (fistCol, secCol) = ( SELECT anotherFistCol, anotherSecondCol FROM mySecondTable ) I am getting: ERROR: syntax error at or near "select" 2. When changed to (only the parentheses are changed): UPDATE myFirstTable SET (fistCol, secCol) = (( SELECT anotherFistCol, anotherSecondCol FROM mySecondTable )) I am getting: ERROR: number of columns does not match number of values Does anybody know, what I am doing wrong? Thank you very much and wish you a luxurious day Adam
