Re: Array comparison & prefix search

Поиск
Список
Период
Сортировка
От Denes Daniel
Тема Re: Array comparison & prefix search
Дата
Msg-id cd515af0912050736n420c7bdescb7b23a917a900c4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Array comparison & prefix search  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
2009/12/5 Merlin Moncure <mmoncure@gmail.com>
 
AFAIK, your approach is the only solution given your requirements.  It
works well...I've used it often, but usually for integers.  Maybe
there is a missing operator for arrays kinda similar to the contains
operator that would be btree indexable.
 
Yes, I also think that an array prefix equality operator would be good to have... but now that I've found it in the documentation that this solution can be relied on (see my other mail), I can work around the lack of that.
 
Thanks,
Denes Daniel

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

Предыдущее
От: Denes Daniel
Дата:
Сообщение: Re: Array comparison & prefix search
Следующее
От: Perry Smith
Дата:
Сообщение: tsvector from external files