Matt Warner <matt(at)warnertechnology(dot)com> writes:
> If I understand this, it looks like this approach allows me to match the
> beginnings and endings of words, but not the middle sections.
Yeah, probably. You might consider using contrib/pg_trgm instead if
you need arbitrary substrings.
regards, tom lane