Subqueries in from clause?

From: Meszaros Attila <tilla(at)draconis(dot)elte(dot)hu>
To: pgsql-sql(at)hub(dot)org
Subject: Subqueries in from clause?
Date: 2000-09-25 16:56:16
Message-ID: Pine.LNX.4.21.0009251830001.368-100000@draconis.csoma.elte.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

My question for this week:
How far is the above subject from beeing implemented?

(I've run through the archives, and found some quite old mails in
this topic. They mentioned automatically generated temp tables as possibe
solutions... Is this the plan even today?)

Attila

Ps.:
Two weeks ago I had a question about multiplee joins. According to Tom's
advice I translated the actual snapshot from cvs and after submitting the
query with parenthesis on the right place I experienced a speedup factor
of 200 (two hundred!!!) comapred to the GEQO. Great.

Ps^2.:
Also tested tuple toasting up to 4Mbytes of single tuples...
I like it :))

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2000-09-25 18:45:49 Re: select
Previous Message Indraneel Majumdar 2000-09-25 07:01:35 Re: Select between two databases