Re: [PERFORM] Hypothetical suggestions for planner, indexing - Mailing list pgsql-hackers

From Dennis Björklund
Subject Re: [PERFORM] Hypothetical suggestions for planner, indexing
Date
Msg-id Pine.LNX.4.44.0305062030540.3364-100000@zigo.dhs.org
Whole thread Raw
In response to Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Barry Lind
Date:
Subject: Re: 7.4 features list
Next
From: Andreas Pflug
Date:
Subject: information_schema OID