Hi,
On 8/25/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> I assume you're referring to this:
>
> http://marc.info/?l=sqlite-users=118737502703454=2
>
Yep, that's it.
> In that specific case, the parens are not needed. But that's not always
> the case. In general, LEFT OUTER JOIN is not
--- "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
I don't think so:
for example logical operations need to be contained like in a ON or
WHERE clause
example" WHERE ((a = "X" AND b = "Y") OR z = "W") AND x = "foo"
if you remove the parenthesis then it will evaluate differently
Bruno S. Oliveira wrote:
Hi there,
Is there any sort of
Won't most arithmetic expressions such as :
SELECT (col1 + col2) * col3
FROM table
require parenthesis ?
Regards,
--
Olivier LE FLOCH
On 25 août 07, at 00:01, Bruno S. Oliveira wrote:
Hi there,
Is there any sort of expression inside a query that needs to be
surrounded by parenthesis?
Hi there,
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
5 matches
Mail list logo
