I was trying to accomplish this on datasets and could not figure out the
magic. Using Model.with(:enqueued, Model.where(status:
'ready').returning.update(status: 'processing')) does not work as expected
in this case.
Here's what I'm trying to replicate:
```with updated_notifications as (
update notification_events
set notification_event_status='PROCESSING'
where id IN (
select id from notification_events e
where notification_event_status = 'ENQUEUED'
order by created_at FOR UPDATE SKIP LOCKED LIMIT 10)
RETURNING *)
select * from updated_notifications order by created_at```
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/7899bcee-8394-44e9-8bc6-37b1552031cdn%40googlegroups.com.
