Re: Simplifying Text Search

Am Montag, 12. November 2007 schrieb Martijn van Oosterhout:
> On Mon, Nov 12, 2007 at 03:44:18PM -0500, Aidan Van Dyk wrote:
> > Can LIKE be easily overloaded in the parser?  So:
> >     text LIKE text
> > works in it's current form, and
> >     tsvector LIKE tsquery
> > also works like the @@?  Or have I gotten all the ts* types all mixed up
> > again...
>
> AIUI LIKE is mashed into an operator at parse time, so yes, if you
> create the operator with the right name it will just work.

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.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/