4 ms·
> why would WHERE clauses need to have a AND instead of multiple WHERE clauses Semi related. Python's for comprehensions allow multiple if's. some_list
by michaelcampbell 4y ago
> why would WHERE clauses need to have a AND instead of multiple WHERE clauses
Semi related. Python's for comprehensions allow multiple if's.
some_list = [ x for x in things
if x % 2 == 0
if my_function(x) > 0
if some_other_global_predicate()
...
]
And this is shown in the python docs.
I've had PR's rejected for using this since they wanted "and". Drove me up a wall as this IMO reads as easily if not more easily than the "and" version, and (again, IMO) is more for humans where the "&&" is more for the computer.