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

Поиск
Список
Период
Сортировка
От MESZAROS Attila
Тема select ... from (select .. from where.. ) where ... ?
Дата
Msg-id Pine.LNX.3.96.990331212513.19290A-100000@chiara.csoma.elte.hu
обсуждение исходный текст
Список 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,anddoing the outer select on a view?
 
Is is planned to implement this feature in the near future?

Thanx
Attila

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Jackson, DeJuan"
Дата:
Сообщение: RE: [SQL] Odd "problem", not sure if there is a solution ....
Следующее
От: Clark Evans
Дата:
Сообщение: Re: [SQL] select ... from (select .. from where.. ) where ... ?