Skip to content
Advertisement

simplifying postgres queries

Note: Asking to improve the working code.

My data column is as follows

In the above data, I want to set available to false and price to zero.

To do this I Am using the below code.

My question is it possible to update both values in a single query?

Thanks.

Advertisement

Answer

Sure:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement