3 ms·
I'm not sure that I follow. The two queries are to demonstrate difference in form; they are not intended to be equivalent. If you're already writing: WHER
by carbocation 6y ago
I'm not sure that I follow. The two queries are to demonstrate difference in form; they are not intended to be equivalent.
If you're already writing:
WHERE foo=bar
AND biz=baz
It's not clear to me how:
WHERE TRUE
AND foo=bar
AND biz=baz
is worse.
- shazzdeeds 6y agoHe’s saying if someone gets in the habit of using that style they have to be very careful. If they forget to change True to False when using an OR that it could have major consequences. Performance being the least of concerns.
- carbocation 6y agoI agree that such an error would be of the catastrophic type. It's interesting that several people seem to perceive this formatting approach as something that would increase the risk of that error. Is the red flag for people the WHERE TRUE on one line? Like, would this be less alarming to people? WHERE TRUE AND x=y