Re: [PERFORM] Hypothetical suggestions for planner, indexing

Поиск
Список
Период
Сортировка
От Dennis Björklund
Тема Re: [PERFORM] Hypothetical suggestions for planner, indexing
Дата
Msg-id Pine.LNX.4.44.0305062030540.3364-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Barry Lind
Дата:
Сообщение: Re: 7.4 features list
Следующее
От: Andreas Pflug
Дата:
Сообщение: information_schema OID