Re: Performance problems with multiple layers of functions - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance problems with multiple layers of functions
Date
Msg-id 8427.1143228229@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance problems with multiple layers of functions  (Svenne Krap <svenne@krap.dk>)
Responses Query plan from hell  (PFC <lists@peufeu.com>)
List 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 by date:

Previous
From: Michael Stone
Date:
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core