3 ms·

Thank you! Thank you so much :)

• porsager 7y ago
  You're welcome. To ensure you're not sending alerts twice either select and update in a transaction or use a CTE like: with alert as ( select alert_id from alerts where alert_sent_at is null ) update alerts set alert_sent_at = now() from alert returning *