Am Dienstag, 13. November 2007 schrieb Gregory Stark:
> "Peter Eisentraut" <peter_e@gmx.net> writes:
> > What we'd need is a way to convert a LIKE pattern into a tsquery
> > ('%foo%bar%' => 'foo & bar'). Then you might even be able to sneak
> > index-optimized text search into existing applications. Might be worth a
> > try.
>
> I don't think that's the right direction to go. Notably "%foo%bar%" isn't
> the same thing as "foo & bar". Also most tsearch queries can't be expressed
> as LIKE patterns anyways.
The requirement is to express LIKE patterns as tsearch queries, not the other
way around.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/