Re: Performance problems with multiple layers of functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance problems with multiple layers of functions
Дата
Msg-id 8427.1143228229@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance problems with multiple layers of functions  (Svenne Krap <svenne@krap.dk>)
Ответы Query plan from hell
Список pgsql-performance
Svenne Krap <svenne@krap.dk> writes:
> Tom Lane wrote:
>> where (flow_direction, dataset_id) in (select * from new_func(122))

> Is this form of multi-column IN mentioned anywhere in the docs? I can't
> find it.

Sure, look under "Subquery Expressions".  8.0 and later refer to it as a
row_constructor, but it's documented at least as far back as 7.3.

            regards, tom lane

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