Re: Performance problems with multiple layers of functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Svenne Krap <svenne(at)krap(dot)dk>
Cc: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems with multiple layers of functions
Date: 2006-03-24 19:23:49
Message-ID: 8427.1143228229@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Svenne Krap <svenne(at)krap(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-24 19:24:04 Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Previous Message Michael Stone 2006-03-24 19:21:24 Re: Scaling up PostgreSQL in Multiple CPU / Dual Core