Tieson Molly <tvmaly(at)gmail(dot)com> writes:
> is there a different construct than the Similar To that would work?
> I know for certain that the first few characters could be different due to
> the nature of geohashes. So I may not be able to optimize the prefix
> aspect in some cases.
Depending on what patterns you're looking for, it's possible that a
trigram index (contrib/pg_trgm) would work better.
regards, tom lane