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 по дате отправления: