Tom Lane wrote:
> The other point is that in non-C locales, a standard varchar index isn't
> usable for LIKE (the sort order is usually wrong). You can re-initdb
> in C locale or create a varchar_pattern_ops index.
booktown=# create index first_name_idx_vpo on auth using btree
(first_name varchar_pattern_ops);
Yeehaw! Now it works. Thanks Tom!