Re: ADD TO UPDATE LIMIT

On Fri, Oct 23, 2020 at 10:32 AM 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;
>

As Christophe said, you failed to describe what you expected to happen. If
you are looking for SQL to protect you from yourself then this is but one
example that suggests that you need to change your general expectations and
just be more diligent about testing your data destructing SQL commands. If
you actually expected it to change a single record when more than one match
you likewise need to change your expectations - though in this case there
isn't much to be done when writing SQL generally.

David J.