David Morgenstern writes:
> Can somebody explain why text_pattern_ops can be used on varchar
> columns, considering it can’t be used for bpchar columns?
The underlying rule there is that an opclass can be applied to an index
column if the column's actual type is binary-coercible to what the opcla
On Fri, 2021-06-25 at 12:29 +0200, David Morgenstern wrote:
> The documentation for operator classes
> (https://www.postgresql.org/docs/current/indexes-opclass.html)
> seems to indicate that text_pattern_ops should only be used for text columns
> and varchar_pattern_ops should be used for varcha