How to make a selection and set a flag in one step?

Question

PostgreSQL

I need to fetch the data for processing and set the processing flag for each record. So that I can take data from the database in several threads and each thread would take its data without interfering with others.

How to do it right? And how to set the is_processing flag for all specified id?

SELECT FROM mytable id, path LIMIT 10;

Answer 1

https://habr.com/ru/post/481556/