Re: [SQL] WHERE parent IN (0,-1)
От | Thomas Lockhart |
---|---|
Тема | Re: [SQL] WHERE parent IN (0,-1) |
Дата | |
Msg-id | 379F180F.F96796FB@alumni.caltech.edu обсуждение исходный текст |
Ответ на | Re: [SQL] WHERE parent IN (0,-1) (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [SQL] WHERE parent IN (0,-1)
|
Список | pgsql-sql |
> >> I can get around the problem (I think) by using WHERE parent IN > >> (0,'-1'). > It's a grammar problem. in_expr_nodes and not_in_expr_nodes expect > the elements of the IN-list to be AexprConst ... I wonder why not > a_expr instead? Might be a reduce conflict, but I bet we could at > least use b_expr. Thomas, any comments? The immediate problem is with handling the minus sign; I should be able to fix that (I had changed the handling of minus signs to get better behavior with cases like "- 1" and "2-1" in other contexts). My recollection is that SQL92 allows only lists of constants, and there may have been shift/reduce problems with doing more than that. Will poke at it in between getting Bruce's man pages going ;) - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California
В списке pgsql-sql по дате отправления: