[tinysql] where condition

[Marcel Ruff]

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
>>
>>    
>>
>
>
>  
>