Re: [SQL] WHERE parent IN (0,-1) - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] WHERE parent IN (0,-1)
Date
Msg-id 9643.933169622@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] WHERE parent IN (0,-1)  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
Bruce Momjian <maillist@candle.pha.pa.us> writes:
>> I can get around the problem (I think) by using WHERE parent IN
>> (0,'-1'). 

> yes, that's a good workaround.  Added to TODO list:

>     * select * from pg_class where oid 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?
        regards, tom lane


pgsql-sql by date:

Previous
From: Remigiusz Sokolowski
Date:
Subject: How to limit number of processes
Next
From: Thomas Lockhart
Date:
Subject: Re: [SQL] WHERE parent IN (0,-1)