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