Am Dienstag, 13. November 2007 schrieb Gregory Stark: > "Peter Eisentraut" <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings