Postgres Pro
Downloads
Home   >   mailing lists

select ... from (select .. from where.. ) where ... ? - Mailing list pgsql-sql

From MESZAROS Attila
Subject select ... from (select .. from where.. ) where ... ?
Date
Msg-id Pine.LNX.3.96.990331212513.19290A-100000@chiara.csoma.elte.hu
Whole thread Raw
List pgsql-sql
Tree view 
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,anddoing the outer select on a view?
 
Is is planned to implement this feature in the near future?

Thanx
Attila

pgsql-sql by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Odd "problem", not sure if there is a solution ....
Next
From: Clark Evans
Date:
Subject: Re: [SQL] select ... from (select .. from where.. ) where ... ?