News for hackers. Stuff that matters.

A comment on An UPDATE without a WHERE, or something close to it. Parent comment

Re:An UPDATE without a WHERE, or something close to it by colinmcd on Friday October 29, 2021 @11:06AM (#29039339)
Predicate order in SQL is pretty dodgy all around and makes it hard to build intuition around SQL queries. In select, the actual SELECT clause (field selection) can usually be conceptualized as “happening” after all other clauses, but of course it comes first in the query.

This problem is fixed in query languages like EdgeQL.[0]

[0] https://www.edgedb.com/docs/edgeql/commands/update

[ Parent | on HN ]
Re:An UPDATE without a WHERE, or something close to it by masklinn on Friday October 29, 2021 @03:23PM (#29042534)
> In select, the actual SELECT clause (field selection) can usually be conceptualized as “happening” after all other clauses

Not quite true, DISTINCT, ORDER BY and TOP/LIMIT happen afterwards.

[ Parent | on HN ]
Re:An UPDATE without a WHERE, or something close to it by hermanradtke on Friday October 29, 2021 @04:44PM (#29043313)
Also, HAVING
[ Parent | on HN ]