Postgresql UPDATE on multiple columns in the same table

Question

Im trying to update multiple columns in the same table. Im using node-postgres Here is what my code looks like.

client.query('UPDATE mytable SET column1 = ($1), column2 = ($2) WHERE id = ($3)',[data.a,data.b,data.id]);

The code goes through with no errors however the columns don't get updated. The data (data.a,data.b,data.id) is defined properly.

Am I missing something vital?

Please try the same thing with literal values in the query. This should give you a hind. — jhinghaus
– jhinghaus, Commented Dec 1, 2017 at 10:03

Aleksandr Chernov · Accepted Answer · 2017-12-06 00:59:49Z

1

Thank you to all who helped.

All through the data was defined properly it was not actually being transferred on POST. Specifically data.id so the node-pg would not give an error but would not go through either since the data.id is missing.

After putting data.id within my form group it was solved.

answered Dec 6, 2017 at 0:59

Aleksandr Chernov

337 bronze badges

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

Collectives™ on Stack Overflow

Postgresql UPDATE on multiple columns in the same table

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