[scarface74]

And if you skip records that you are depending on for your poor man’s queue, aren’t you just hiding bugs?

[Spivak]

No? Unless there's some edge case with that statement I don't know about. That statement is basically tailor made for queues so you can select jobs that aren't currently being worked on by other workers.

Inasmuch as you trust your db's locking correctness it eliminates the concurrency issues. You can very naively have n workers pulling jobs from a queue not stepping on each-other.