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 по дате отправления