Re: [HACKERS] subselects - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] subselects
Date
Msg-id 34B7B2BF.44FE7252@sable.krasnoyarsk.su
Whole thread Raw
Responses Re: [HACKERS] subselects  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:
>
> OK, a few questions:
>
>         Should we use sortmerge, so we can use our psort as temp tables,
> or do we use hashunique?
>
>         How do we pass the query to the optimizer?  How do we represent
> the range table for each, and the links between them in correlated
> subqueries?

My suggestion is just use varlevel in Var and don't put upper query'
relations into subquery range table.

Vadim

pgsql-hackers by date:

Previous
From: "Vadim B. Mikheev"
Date:
Subject: Re: subselects
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] subselects