> Well if stuff like that ends up in Postgresql would it be possible to index
> LIKE '%xxx%' searches? That way all people have to do is create the
> relevant index and use a fts_ops or something, and voila LIKE '%xxx%'
> searches become faster, with maybe some performance+disk space hit for
> Would something like that be difficult to implement? I'm not sure how
> function+fts index would work either.
> I hope FTS for postgresql doesn't start looking like Oracle's
> Context/Intermedia... Proprietary interfaces == "lock in" == "ick".
This is what I was hoping... Something to make it automatic.
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
In response to
pgsql-hackers by date
|Next:||From: Thomas Lockhart||Date: 2001-04-28 01:49:09|
|Subject: Re: Any optimizations to the join code in 7.1?|
|Previous:||From: Lincoln Yeoh||Date: 2001-04-28 01:29:35|
|Subject: Re: The new, the improved ... FTS Searching of Mailing List