Re: [SQL] Using intersect in subquery

> >> (I believe) I am running PG 6.4.  The INTERSECT by itself works, but not in
> >> a subquery.
> >> 
> 
> No, it still won't work --- the current grammar specifies SubSelect not
> select_clause as the kind of select you can put inside an expression.
> Not sure what it would take to fix this; I have a feeling that just
> changing the grammar wouldn't be good enough :-(.  Better add it to the
> TODO list:
>     * Support UNION/INTERSECT/EXCEPT in sub-selects

Done.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026