From: Clark Evans <clark.evans@manhattanproject.com>
To: MESZAROS Attila <tilla@chiara.csoma.elte.hu>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] select ... from (select .. from where.. ) where ... ?
Date: Wed, 31 Mar 1999 20:00:45 +0000
Message-ID: <37027EED.1FC9EA51@manhattanproject.com> (raw)
References: <Pine.LNX.3.96.990331212513.19290A-100000@chiara.csoma.elte.hu>
MESZAROS Attila wrote:
> I'am faced with a huge system using the above kind of queries.
> It was originally written and tested with adabas.
I wrote a hudge system using those kind of queries. Very
useful buggers, really helps you manage complexity. I bet
it plays hudge games with the optimizer though...
> Unfortunatelly 6.4 does support subqueries only in the 'where' expression,
> as far as I undersood...
That's my understanding. 6.5 will not support it either.
> My questions are:
> How can I port this program with the least effort?
> Shall I create views corresponding to the subqueries,
> and doing the outer select on a view?
You can do this, as long as the inner select does not
have an aggregate. If it has an aggregate _or_ uses an
outer join then you need to code up functions that
do the outer-join.
> Is is planned to implement this feature in the near future?
I hope so. Actually, I think this is a generalization of the HAVING
clause. About 2 years ago (using Oracle) I dropped using the HAVING
clause due to this form... so, there is another possibility,
see if you can re-write these queries to use HAVING.
Let me know if I can help more.
Clark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: clark.evans@manhattanproject.com, tilla@chiara.csoma.elte.hu, pgsql-sql@hub.org
Subject: Re: [SQL] select ... from (select .. from where.. ) where ... ?
In-Reply-To: <37027EED.1FC9EA51@manhattanproject.com>
References: <Pine.LNX.3.96.990331212513.19290A-100000@chiara.csoma.elte.hu> <37027EED.1FC9EA51@manhattanproject.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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