On Tue, 26 Jul 2005, Joseph Shraibman wrote:
> I have this index:
>
> "directory_lower_username_seg_key" unique, btree (lower(username)
> text_pattern_ops, seg)
>
> ... but my query refuses to use that index.
text_pattern_ops is an opclass for doing LIKE queries using the index, I
don't believe it's used for equality comparisons.