Re: [SQL] Nested Views take forever

Поиск
Список
Период
Сортировка
От marten@feki.toppoint.de
Тема Re: [SQL] Nested Views take forever
Дата
Msg-id 199911120742.IAA05096@feki.phoenix-edv.netzservice.de
обсуждение исходный текст
Ответ на Re: [SQL] Nested Views take forever  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
> 
> There's been some talk of reimplementing WHERE ... IN ... so that it
> does something intelligent without help, but there are a lot of
> higher-priority problems on the TODO list...
> 
>             regards, tom lane
This only affect statement, where the "inner" select accesses some
stuff of the "outer" select statement ? Actually a statement like:
select * from table where index in  (select foreign-key from table2 where table2.name = 'Hallo')

would not have such problems ? Correct ?

Marten





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

Предыдущее
От: "Klein, Robert"
Дата:
Сообщение: Trying to move a 6.1 database to 6.5
Следующее
От: marten@feki.toppoint.de
Дата:
Сообщение: Re: [SQL] HAVING in EXISTS-clause ...