Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group