On Tue, 2007-11-13 at 13:32 +0100, Peter Eisentraut wrote: > 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.
+1 -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster