Re: Index use difference betweer LIKE, LIKE ANY?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Index use difference betweer LIKE, LIKE ANY?
Дата
Msg-id 4D696CFE.2010107@agliodbs.com
обсуждение исходный текст
Ответ на Index use difference betweer LIKE, LIKE ANY?  ("Sam Wong" <sam@hellosam.net>)
Ответы Re: Index use difference betweer LIKE, LIKE ANY?  (Chetan Suttraway <chetan.suttraway@enterprisedb.com>)
Список pgsql-performance
Дерево обсуждения 
On 2/25/11 5:31 AM, Sam Wong wrote:
> I found that "LIKE", "= ANY (...)", "LIKE .. OR LIKE .." against a text
> field used the index correctly, but not "LIKE ANY (...)". Would that be a
> bug?

No, it would be a TODO.  This is a known limitation; it needs some
clever code to make it work, and nobody's written it.

--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Picking out the most recent row using a time stamp column
Следующее
От: Dave Johansen
Дата:
Сообщение: Re: Picking out the most recent row using a time stamp column