Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> On 12/31/15 9:02 AM, Tom Lane wrote:
>> If you don't want to rebuild the whole database, you can create indexes to
>> support this by declaring them with COLLATE "C", or the older way is to
>> declare them with text_pattern_ops as the index opclass.
> Do you have to do anything special in the query itself for COLLATE "C"
> to work?
No.
> I didn't realize the two methods were equivalent.
Well, they're not equivalent exactly, but indxpath.c knows that either
way produces an index that will work for LIKE.
regards, tom lane