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

Sun, 11 Jan 1998 00:41:19 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] subselects
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

Sun, 11 Jan 1998 00:58:52 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] subselects
> 
> 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
> 

OK.

-- 
Bruce Momjian
maillist@candle.pha.pa.us

Sun, 11 Jan 1998 00:23:29 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] subselects