Prefix operator for text and spgist support

Поиск
Список
Период
Сортировка
Искать
От
Ildus Kurbangaliev
Тема
Prefix operator for text and spgist support
Дата
Msg-id
20180202180327.222b04b3@wp.localdomain
Список
Дерево обсуждения
Prefix operator for text and spgist support Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
Re: Prefix operator for text and spgist support Arthur Zakirov <a.zakirov@postgrespro.ru>
Re: Prefix operator for text and spgist support Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
Re: Prefix operator for text and spgist support Arthur Zakirov <a.zakirov@postgrespro.ru>
Re: Prefix operator for text and spgist support Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
Re: Prefix operator for text and spgist support Teodor Sigaev <teodor@sigaev.ru>
Re: Prefix operator for text and spgist support Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Prefix operator for text and spgist support Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
Re: Prefix operator for text and spgist support Teodor Sigaev <teodor@sigaev.ru>
Re: Prefix operator for text and spgist support Emre Hasegeli <emre@hasegeli.com>
Re: Prefix operator for text and spgist support Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
Hi,

Attached patch introduces prefix operator ^@ for text type. For 'a ^@ b'
it returns true if 'a' starts with 'b'. Also there is spgist index
support for this operator.

It could be useful as an alternative for LIKE for 'something%'
templates. Or even used in LIKE queries instead of ~>=~ and ~<~ in the
future. But it would require new strategy for btree.

-- 
---
Ildus Kurbangaliev
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Robert Haas
Дата:
FAQ