On Fri, Mar 24, 2006 at 01:49:17PM +0100, Svenne Krap wrote:
explain select dataset_id, entity, sum(amount) from entrydata_current
where flow_direction in (select * from outflow_direction(dataset_id))
and dataset_id in (select * from get_dataset_ids(122)) group by
dataset_id, entity;
snip
Jim C. Nasby [EMAIL PROTECTED] writes:
On Fri, Mar 24, 2006 at 01:49:17PM +0100, Svenne Krap wrote:
explain select dataset_id, entity, sum(amount) from entrydata_current
where flow_direction in (select * from outflow_direction(dataset_id))
and dataset_id in (select * from
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.
Svenne
smime.p7s
Description: S/MIME Cryptographic Signature
Svenne Krap [EMAIL PROTECTED] 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,