"Peter Eisentraut" <[EMAIL PROTECTED]> writes: > 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.
As an optimization to use GIST indexes this is a cool idea. Much like our existing functionality which converts "col LIKE 'bar%'" to range queries so it can use btree indexes. But it doesn't help the people who find "col @@ 'foo & bar'" confusing. They're just being thrown off because "@@" is an unfamiliar operator. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings