Re: ADD TO UPDATE LIMIT

> On Oct 23, 2020, at 09:36, Andrey Furs <aefurs93(at)gmail(dot)com> wrote:
>
> Hi there!
> Are you serious !?
> Postgresql not UPDATE LIMIT !?
>
> UPDATE table SET id=100 WHERE id<1000 LIMIT 1;
>
> OMG!

What does that even mean, though? There's no guarantee as to which row is going to be updated, even if that syntax worked. LIMIT without an ORDER BY is not statistically random enough to be useful for true randomness, but is not defined enough to be safe. What you probably want is:

UPDATE t SET id=100 WHERE id = ( SELECT id FROM t ORDER BY id LIMIT 1);

--
-- Christophe Pettus
xof(at)thebuild(dot)com