Re: [SQL] WHERE parent IN (0,-1)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Drew Whittle <drew(at)albatross(dot)co(dot)nz>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] WHERE parent IN (0,-1)
Date: 1999-07-28 13:47:02
Message-ID: 9643.933169622@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Lockhart 1999-07-28 14:47:43 Re: [SQL] WHERE parent IN (0,-1)
Previous Message Remigiusz Sokolowski 1999-07-28 09:47:33 How to limit number of processes