Re: Pushing ScalarArrayOpExpr support into the btree index AM

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Pushing ScalarArrayOpExpr support into the btree index AM
Дата
Msg-id 15387.1318779217@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Pushing ScalarArrayOpExpr support into the btree index AM  (Noah Misch <noah@leadboat.com>)
Список pgsql-hackers
Noah Misch <noah@leadboat.com> writes:
> On Sat, Oct 15, 2011 at 02:58:45PM -0400, Tom Lane wrote:
>> [algorithm for a regular index scan satisfying "key IN (...)"]

> Sounds sensible.  The algorithm applies to more than ScalarArrayOpExpr; is it
> not the ability to handle an OR'ed list of ScanKey instead of an AND'ed one?

No, because it's restricted to all the elements having the same operator
and same index column; it's not a generic OR.
        regards, tom lane


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

Предыдущее
От: Kohei KaiGai
Дата:
Сообщение: Re: [v9.2] Fix Leaky View Problem
Следующее
От: Jan Urbański
Дата:
Сообщение: proposal: set GUC variables for single query