Received: from localhost (IDENT:root@hectic-1.jpl.nasa.gov [128.149.68.203]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA85630 for ; Wed, 28 Jul 1999 10:48:17 -0400 (EDT) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id OAA05607; Wed, 28 Jul 1999 14:47:44 GMT Sender: lockhart@hub.org Message-ID: <379F180F.F96796FB@alumni.caltech.edu> Date: Wed, 28 Jul 1999 14:47:43 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: Drew Whittle , pgsql-sql@postgreSQL.org Subject: Re: [SQL] WHERE parent IN (0,-1) References: <9643.933169622@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > >> 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