"UPDATE table_name SET w = $1, x = $2, z = $4 WHERE y = $3 RETURNING *",
does not do the same as
"UPDATE table_name SET w = $1, x = $2, y = $3, z = $4 RETURNING *",
It’s 2 am and my mind blanked out the WHERE, and just wanted the numbers neatly in order of 1234.
idiot.
FML.
You must log in or register to comment.
Always SELECT first. No exceptions.
mind explaining?
I did when I made the query a year ago. Dumdum sleep deprived brain thought it would look more organised this way