Re: slow IN() clause for many cases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: slow IN() clause for many cases
Дата
Msg-id 8063.1129331357@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: slow IN() clause for many cases  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: slow IN() clause for many cases  (David Fetter <david@fetter.org>)
Re: slow IN() clause for many cases  (mark@mark.mielke.cc)
Re: slow IN() clause for many cases  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
I wrote:
> I'm thinking that IN should be
> converted to a ScalarArrayOpExpr, ie

>     x = ANY (ARRAY[val1,val2,val3,val4,...])

Actually, there is one little thing in the way of doing this: it'll
fail if any of the IN-list elements are NULL, because we have not got
support for arrays with null elements.  So we'd have to fix that first.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: slow IN() clause for many cases
Следующее
От: David Fetter
Дата:
Сообщение: Re: slow IN() clause for many cases