Re: [HACKERS] subselects
Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>
From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: PostgreSQL-development <hackers@postgreSQL.org>
Date: 1998-01-10T17:41:19Z
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