Re: Simplifying Text Search

From: Aidan Van Dyk <aidan(at)highrise(dot)ca>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simplifying Text Search
Date: 2007-11-12 20:44:18
Message-ID: 20071112204418.GI10585@yugib.highrise.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Heikki Linnakangas <heikki(at)enterprisedb(dot)com> [071112 15:18]:
> Simon Riggs wrote:

> >Right now, Full Text Search SQL looks like complete gibberish and it
> >dissuades many people from using what is an awesome set of features. I
> >just want to add a little sugar to help people get started.

> Granted, @@ is a bit awkward until you get used to it. "x LIKE y" would
> read out better, but unfortunately that's already taken ;-).

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...

But it doesn't buy anything except avoiding the "@@" that people seem to not
grok easily, and it might actually cause more grief, because of people
confusing the 2 forms of LIKE.

a.

--
Aidan Van Dyk Create like a god,
aidan(at)highrise(dot)ca command like a king,
http://www.highrise.ca/ work like a slave.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-11-12 20:47:56 Re: Simplifying Text Search
Previous Message Alvaro Herrera 2007-11-12 20:35:20 Re: Simplifying Text Search