Re: Difference between text_pattern_ops and varchar_pattern_ops

2021-06-25 Thread Tom Lane
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

Re: Difference between text_pattern_ops and varchar_pattern_ops

2021-06-25 Thread Laurenz Albe
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