Prefix operator for text and spgist support
Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
From: Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>
To: pgsql-hackers@lists.postgresql.org
Date: 2018-02-02T15:03:27Z
Lists: pgsql-hackers
Attachments
- prefix_operator_and_spgist.patch (text/x-patch) patch
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
Commits
-
Add prefix operator for TEXT type.
- 710d90da1fd8 11.0 landed