> <featurerequest>
> 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
> inserts.
>
> 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".
> </featurerequest>
This is what I was hoping... Something to make it automatic.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026