--- "Bruno S. Oliveira" <[EMAIL PROTECTED]> wrote: > Is there any sort of expression inside a query that needs to be > surrounded by parenthesis? > > My program will receive queries built to run in MySQL, Oracle and > Postgrees. The problem, as posted before, is that SQLite has problems > with parenthesis around JOINs... So, what I want to do is to remove > every possible parenthesis present in the incoming query. So that my > problem is resolved fast.
I assume you're referring to this: http://marc.info/?l=sqlite-users&m=118737502703454&w=2 In that specific case, the parens are not needed. But that's not always the case. In general, LEFT OUTER JOIN is not commutative, nor is it associative. You cannot blindy strip the parens or reorder the outer joins out of context. ____________________________________________________________________________________ Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
