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.

Reply via email to