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

From Vadim B. Mikheev
Subject Re: [HACKERS] subselects
Date
Msg-id 34B7B6DC.937E1B8D@sable.krasnoyarsk.su
Whole thread Raw
In response to Re: [HACKERS] subselects  ("Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>)
List pgsql-hackers
Vadim B. Mikheev wrote:
>
> 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.

Hmm... Sorry, it seems that I did reply to very old message - forget it.

Vadim

pgsql-hackers by date:

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