Seamus Abshere wrote:
> I created an index with text_pattern_ops because I want fast prefix search [1] [2].
>
> ...but I don't think it's working when I use a column reference || '%'...
An index can only be used for expressions like
<indexed expression> <operator from the opclass> <constant>
and you have a column refrence on the right side.
Perhaps you can rephrase your query in such a fashion.
Yours,
Laurenz Albe