Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Lockhart
Subject Re: [SQL] WHERE parent IN (0,-1)
Date
Msg-id 379FCA36.8DE4CC1F@alumni.caltech.edu
Whole thread Raw
In response to Re: [SQL] WHERE parent IN (0,-1)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
> >> 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?
> Indeed, there is no reduce conflict created by using a_expr, so I went
> ahead and committed it.  Also tidied the list-generating code a bit.

Great. Did you fix all the places where IN (values) is allowed? I was
doing that, but will merge your fixes...
                - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California

pgsql-sql by date:

Previous
From: "Inform(ñËÕÔÓËÜÎÅÒÇÏ)"
Date:
Subject: Form making with psql and php.cgi
Next
From: Tom Lane
Date:
Subject: Re: [SQL] COALESCE() bug?