Re: [HACKERS] temporary indexes

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: [HACKERS] temporary indexes
Дата
Msg-id 20060228180837.GA1593@uio.no
обсуждение исходный текст
Ответ на Re: [HACKERS] temporary indexes  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
On Tue, Feb 28, 2006 at 11:55:32AM -0600, Kevin Grittner wrote:
>> Also, EXISTS works in situations where
>> you need to compare on multiple columns, so it is useful in many
>> situations where EXISTS or MIN/MAX techniques just don't work.
> Sorry.  That should have read:
>
> EXISTS works in situations where
> you need to compare on multiple columns, so it is useful in many
> situations where IN or MIN/MAX techniques just don't work.

Can't you just do WHERE (foo,bar) IN ( SELECT baz,quux FROM table )? I'm
quite sure I've done that a number of times.

/* Steinar */
--
Homepage: http://www.sesse.net/

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] temporary indexes
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [HACKERS] temporary indexes