How to Do UPDATE … LIMIT in PostgreSQL (With Standard SQL Alternatives) (from MinervaDB Blog)
If you have ever migrated a workload from MySQL to PostgreSQL, you have probably hit a wall the first time you tried to run a statement like UPDATE mytable SET status = 'done' LIMIT 100;. [...]
[...]
