[tinysql] where condition

[Taq]

Hi,

ok, now the expressions take care of operator evaluation order. Every operator got a 
preference level, higher levels are evaluated first.

and, or                level 0
==, <, >, <>, <=, >=   level 1
+,-                    level 2
*,/                    level 3

Now the test for the select returns 2 rows. The changes are in the cvs.

Have more fun,
said Thomas

----- Original Message ----- 
From: "Marcel Ruff" <ruff@swand.lake.de>
To: <tinysql@as220.org>
Sent: Tuesday, October 22, 2002 11:30 PM
Subject: Re: [tinysql] where condition


> Edson Alves Pereira wrote:
> 
> >  I think that now tinySQL has full suport for SQL syntax as Taquara said but we must check it.
> >
> I played a bit, but i think the where clause is broken (current cvs 
> snaphot):
> 
> SELECT * FROM people where pe_name='Hef'               -> OK
> 
> SELECT * FROM people where pe_name='Hef' or pe_name='Bull Lee'     -> 
> ERROR: returns nothing instead of two results
> 
> SELECT * FROM people where pe_name in ('Hef', 'Bull Lee')  -> Exception: 
> 'in' not implemented
> 
> Ok, i should have read parser.txt earlier, 'like', 'in', 'between' etc 
> are not implemented.
> 
> A functional 'or' would be very helpful, has anybody plans to
> extend the parser?
> 
> thanks,
> 
> Marcel
> 
> 
> >
> >Marcel Ruff <ruff@swand.lake.de> wrote:
> >
> >  
> >
> >>Hi,
> >>
> >>is there a list somewhere or does anybody know which
> >>WHERE syntax is currently supported?
> >>
> >>I support for AND, OR, LIKE, IN etc. available?
> >>
> >>thanks
> >>
> >>Marcel
> >>
> >>_______________________________________________
> >>tinysql mailing list
> >>tinysql@as220.org
> >>http://as220.org/mailman/listinfo/tinysql
> >>
> >>    
> >>
> >
> >
> >  
> >
> 
> 
> 
> _______________________________________________
> tinysql mailing list
> tinysql@as220.org
> http://as220.org/mailman/listinfo/tinysql
>