Tom Lane wrote:
> Clayton Cottingham <drfrog@smartt.com> writes:
> > thanks for all those 'like' tips i was wonderinng, would using regex be the
> > same as far as the indexing rules go?
>
> It's equivalent --- an index can help if the pattern is anchored to the
> start of the string. Of course the pattern notation is different...
>
> regards, tom lane
what about helper software like glimpse, as per my other thread?
i was told to use glimpse, because full text index {fti} isnt robust enough to
handle large db's
what do you think the most optimized way of handling this sort of thing would
be?