select ... from (select .. from where.. ) where ... ?

From: MESZAROS Attila <tilla(at)chiara(dot)csoma(dot)elte(dot)hu>
To: pgsql-sql(at)hub(dot)org
Subject: select ... from (select .. from where.. ) where ... ?
Date: 1999-03-31 19:35:18
Message-ID: Pine.LNX.3.96.990331212513.19290A-100000@chiara.csoma.elte.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I'am faced with a huge system using the above kind of queries.
It was originally written and tested with adabas.

Unfortunatelly 6.4 does support subqueries only in the 'where' expression,
as far as I undersood...

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?

Is is planned to implement this feature in the near future?

Thanx
Attila

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Clark Evans 1999-03-31 20:00:45 Re: [SQL] select ... from (select .. from where.. ) where ... ?
Previous Message Jackson, DeJuan 1999-03-31 16:54:01 RE: [SQL] Odd "problem", not sure if there is a solution ....