Tom Lane wrote:
> Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> writes:
>> Is there anything that "varchar_pattern_ops" is needed for that "text_pattern_ops" cannot provide?
>
> Lack of surprise? If you're creating a pattern index on a varchar column,
> you'd likely expect to need to mention varchar_pattern_ops.
>
> The idea that varchar is an alias for text might be second nature to old
> Postgres hands, but it's not to most of the world.
Thanks for the explanation!
Yours,
Laurenz Albe