> On Oct 23, 2020, at 09:36, Andrey Furs <aefurs93@gmail.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
definedenough 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@thebuild.com
