Hello everyone I'm struggling to find the right documentation to accomplish an update query which performs updates on many rows in one go. The equal SQL statement looks like this:
UPDATE order_lines AS ol SET ol.material_cost = val.material_cost FROM ( VALUES (1, 150), (2, 320) ) AS val(id, material_cost) WHERE ol.id = val.id; I'm right now resorting to string interpolation and raw SQL to perform this query but I'd like to write things a little bit more elegant. I'd be very thankful for pointers to the right piece of documentation! Best, Emil -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
