Re: [HACKERS] subselects

From: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] subselects
Date: 1998-01-10 17:41:19
Message-ID: 34B7B2BF.44FE7252@sable.krasnoyarsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim B. Mikheev 1998-01-10 17:58:52 Re: [HACKERS] subselects
Previous Message Vadim B. Mikheev 1998-01-10 17:19:08 Re: subselects