up1/1.txt

## 1.txt
WITH cte AS (
    SELECT id FROM tasks WHERE status = 'pending' ORDER BY created_at ASC LIMIT 1 FOR UPDATE SKIP LOCKED
)

UPDATE tasks SET status = 'in_progress'
FROM cte
WHERE tasks.id = cte.id
RETURNING tasks.*;
	WITH cte AS (
	SELECT id FROM tasks WHERE status = 'pending' ORDER BY created_at ASC LIMIT 1 FOR UPDATE SKIP LOCKED
	)

	UPDATE tasks SET status = 'in_progress'
	FROM cte
	WHERE tasks.id = cte.id
	RETURNING tasks.*;
No results found