Re: SQL grammar

2008-05-12 Thread Evan Lavelle
Evan Lavelle wrote: Check the logs, as Hans suggests. For starters, though, what's this: NOT IN ((SELECT '*' FROM SCONST)) What sort of 'search_cond' is it? First branch, second branch, or both? It can't be both; that's a conflict. Sorry, didn't read your first post; seems you already knew t

Re: SQL grammar

2008-05-12 Thread Evan Lavelle
Check the logs, as Hans suggests. For starters, though, what's this: NOT IN ((SELECT '*' FROM SCONST)) What sort of 'search_cond' is it? First branch, second branch, or both? It can't be both; that's a conflict. Evan ___ help-bison@gnu.org http://

Re: SQL grammar

2008-05-10 Thread Hans Aberg
On 8 May 2008, at 17:49, RichardT wrote: please let me know if there is another forum where I can post my question. The Usenet newsgroup comp.compilers. I am writing a parser to parse SQL (actually T-SQL for MS Sql Server). Or netsearch for links like http://savage.net.au/SQL/ I am get

Re: SQL grammar

2008-05-10 Thread RichardT
7;(' expression ')' | '(' query_specification ')' ; query_specification:SELECT '*' FROM table ; table: SCONST ; %% -- View this message in context: http://www.nabble.com/SQL-grammar-t

SQL grammar

2008-05-10 Thread RichardT
= The ambiguity arise when I give a statement like this: Statement #3: select b from s where b not in ( (select a from t where a = 1) ); The parser can treat the search condition as an exp_list or a query_list. Can someone point me out how to formulate