CodingForums.com - View Single Post

Old Pedant · 12-01-2012, 07:50 AM

Too general a question. Depends entirely upon what the WHERE condition is supposed to be testing.

Code:

WHERE age >= 18 OR age >= 16 AND parentalConsent = True

There is an AND condition at the end with no parentheses at all, yet the meaning is perfectly clear:

It means the same as

Code:

WHERE age >= 18 OR ( age >= 16 AND parentalConsent = True )

*clearly* it would be a mistake to use

Code:

WHERE ( age >= 18 OR age >= 16 ) AND parentalConsent = True

When in doubt, probably use them. But use them correctly.

12-01-2012, 07:50 AM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,200 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	Too general a question. Depends entirely upon what the WHERE condition is supposed to be testing. Code: WHERE age >= 18 OR age >= 16 AND parentalConsent = True There is an AND condition at the end with no parentheses at all, yet the meaning is perfectly clear: It means the same as Code: WHERE age >= 18 OR ( age >= 16 AND parentalConsent = True ) clearly it would be a mistake to use Code: WHERE ( age >= 18 OR age >= 16 ) AND parentalConsent = True When in doubt, probably use them. But use them correctly. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.