Re: [GENERAL] Equivalence Classes when using IN

Поиск
Список
Период
Сортировка
От Kim Rose Carlsen
Тема Re: [GENERAL] Equivalence Classes when using IN
Дата
Msg-id 00313177-8506-43BC-9F6B-2C19F0E5A98B@hiper.dk
обсуждение исходный текст
Ответ на Re: [GENERAL] Equivalence Classes when using IN  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] Equivalence Classes when using IN
Список pgsql-general
Дерево обсуждения 
> Yeah.  The ORDER BY creates a partial optimization fence, preventing
> any such plan from being considered.
>>

I can see in the general case it semanticly means different things If you allow the WHERE to pass through ORDER BY.

A special case can be allowed for WHERE to pass the ORDER BY if the column is part of DISTINCT ON.




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: rverghese
Дата:
Сообщение: Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication
Следующее
От: David Rowley
Дата:
Сообщение: Re: [GENERAL] Equivalence Classes when using IN