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)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] WHERE parent IN (0,-1)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] WHERE parent IN (0,-1)