[other_herbert]

I'm curious why you need this? As a safety mechanism?

You could just do a select with the limit then update that row from the primary key...

[lucb1e]

Sure, with a Turing compete system everything is a "you could just". It seems a lot easier to update limit 1 than to involve a subquery. If that is what GP meant it for, of course.