Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA75824 for ; Wed, 28 Jul 1999 09:49:54 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id JAA09645; Wed, 28 Jul 1999 09:47:02 -0400 (EDT) To: Thomas Lockhart cc: Drew Whittle , pgsql-sql@postgreSQL.org Subject: Re: [SQL] WHERE parent IN (0,-1) In-reply-to: Your message of Tue, 27 Jul 1999 20:09:07 -0400 (EDT) <199907280009.UAA20176@candle.pha.pa.us> Date: Wed, 28 Jul 1999 09:47:02 -0400 Message-ID: <9643.933169622@sss.pgh.pa.us> From: Tom Lane Bruce Momjian 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