| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hamid Khoshnevis <hamid(at)emarq(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] Using intersect in subquery |
| Date: | 1999-08-18 15:10:38 |
| Message-ID: | 199908181510.LAA02000@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> >> (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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Drew Whittle | 1999-08-18 23:59:21 | Counting the number of distinct rows returned |
| Previous Message | Herouth Maoz | 1999-08-18 14:21:39 | Re: [SQL] Using intersect in subquery |