| From: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | jim(at)nasby(dot)net, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] Hypothetical suggestions for planner, indexing |
| Date: | 2003-05-06 18:32:01 |
| Message-ID: | Pine.LNX.4.44.0305062030540.3364-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Tue, 6 May 2003, Tom Lane wrote:
> > It would be nice to add support for multi-column IN..
> > WHERE (a, b, c) IN (SELECT a, b, c ...)
>
> RTFM...
Maybe he did read the manual:
6.15.3. IN (subquery form)
expression IN (subquery)
The right-hand side of this form of IN is a parenthesized subquery, which
must return exactly one column.
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2003-05-06 19:27:03 | information_schema OID |
| Previous Message | Tom Lane | 2003-05-06 16:52:37 | Re: 7.4 features list |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-05-06 19:33:15 | Re: Looking for a cheap upgrade (RAID) |
| Previous Message | scott.marlowe | 2003-05-06 18:12:51 | Re: Looking for a cheap upgrade (RAID) |