To answer my own question - Jeremy posted this reply to a slightly differently worded question back in December:
https://groups.google.com/d/msg/sequel-talk/6VHA-7XQ6R4/5B6hofxaBAAJ On Monday, August 27, 2018 at 11:53:28 AM UTC-7, Joseph Kowalski wrote: > > Is there a sequel way to do updates using a FROM clause to update multiple > specific rows with specific data per row? > > The raw sql example from Stack Overflow ( > https://stackoverflow.com/questions/18797608/update-multiple-rows-in-same-query-using-postgresql#18799497) > > looks like this: > > update test as t set > column_a = c.column_afrom (values > ('123', 1), > ('345', 2) ) as c(column_b, column_a) where c.column_b = t.column_b; > > > Thanks! > -- 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.
