Pattern matching operators a index

Поиск
Список
Период
Сортировка
От soroosh sardari
Тема Pattern matching operators a index
Дата
Msg-id CAFUsPDZTP-eHTFqo6r49i+iAb9QxHtxPE624WMzuJrMJ-Ph1wA@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hi

I'm developing a new type for character string, like varchar. I wrote operators for btree and so forth.
I wonder how pattern matching operators using btree index, because btree operator class ony knows about >, >=, <=, and = operators, but operators for pattern matching, such as LIKE, are not known for btree access method.

Now my question is:
Is Postgre using btree for pattern matching query for varchar or other character string types?

If it does, how i implement it for my new type?

Regards,
Soroosh

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

Предыдущее
От: pilum.70@uni-muenster.de
Дата:
Сообщение: Re: pg_stat_statements: calls under-estimation propagation
Следующее
От: Robert Haas
Дата:
Сообщение: Re: dynamic shared memory: wherein I am punished for good intentions