Re: Re: Does PostgreSQL support EXISTS?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: Does PostgreSQL support EXISTS?
Дата
Msg-id 26668.992447426@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re: Does PostgreSQL support EXISTS?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Re: Does PostgreSQL support EXISTS?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Are we anywhere with optimizing IN to EXISTS?  I didn't think there was
> any work being done in that area.

I don't think it's that hard to do within the outer-join mechanism,
except for this little issue about NULLs.  The planner already makes
querytree alterations of comparable complexity, to deal with views and
subselects...

            regards, tom lane

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

Предыдущее
От: BELLON Michel
Дата:
Сообщение: Compilation of contrib of postgresql 7.1.2 with cygwin 1.3.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.1.2 temporary file area