Prefix operator for text and spgist support - Mailing list pgsql-hackers

From Ildus Kurbangaliev
Subject Prefix operator for text and spgist support
Date
Msg-id 20180202180327.222b04b3@wp.localdomain
Whole thread Raw
Responses Re: Prefix operator for text and spgist support
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] path toward faster partition pruning
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] [PATCH] Lockable views