pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSubqueries in from clause?
4+ messages / 3 participants
[nested] [flat]
* Subqueries in from clause?
@ 2000-09-25 16:56 Meszaros Attila <tilla@draconis.elte.hu>
0 siblings, 1 reply; 4+ messages in thread
From: Meszaros Attila @ 2000-09-25 16:56 UTC (permalink / raw)
To: pgsql-sql@hub.org
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 :))
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Subqueries in from clause?
@ 2000-09-25 20:29 Tom Lane <tgl@sss.pgh.pa.us>
parent: Meszaros Attila <tilla@draconis.elte.hu>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2000-09-25 20:29 UTC (permalink / raw)
To: Meszaros Attila <tilla@draconis.elte.hu>; +Cc: pgsql-sql@hub.org
Meszaros Attila <tilla@draconis.elte.hu> writes:
> How far is the above subject from beeing implemented?
I'm looking at it right now ... no promises yet, though.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Subqueries in from clause
@ 2000-11-03 17:36 Pierre Habraken <Pierre.Habraken@imag.fr>
0 siblings, 1 reply; 4+ messages in thread
From: Pierre Habraken @ 2000-11-03 17:36 UTC (permalink / raw)
To: pgsql-sql
It looks like if subqueries in from clause are not supported by
PostgreSQL. Am I right ? If yes, are there any plans to provide this
feature soon ?
I would like to use Postgres for teaching SQL as a replacement for a
well known commercial product which I find too heavy, too not open
source, too everything ! For this kind of usage I need most SQL92
features, at least for query expression.
Thanks for any information or advice about this topics.
Pierre
--
________________________________________________________________________
Pierre HABRAKEN - mailto:Pierre.Habraken@imag.fr
Tél: 04 76 82 72 48 - Fax: 04 76 82 72 87
IMAG-LSR BP72 38402 SAINT MARTIN D'HERES Cedex
________________________________________________________________________
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Subqueries in from clause
@ 2000-11-03 17:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: Pierre Habraken <Pierre.Habraken@imag.fr>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2000-11-03 17:48 UTC (permalink / raw)
To: Pierre Habraken <Pierre.Habraken@imag.fr>; +Cc: pgsql-sql
Pierre Habraken <Pierre.Habraken@imag.fr> writes:
> It looks like if subqueries in from clause are not supported by
> PostgreSQL. Am I right ? If yes, are there any plans to provide this
> feature soon ?
Already there in current sources for 7.1 ...
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-11-03 17:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-25 16:56 Subqueries in from clause? Meszaros Attila <tilla@draconis.elte.hu>
2000-09-25 20:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-11-03 17:36 Subqueries in from clause Pierre Habraken <Pierre.Habraken@imag.fr>
2000-11-03 17:48 ` Re: Subqueries in from clause Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox