| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Trevor Talbot <quension(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Aidan Van Dyk <aidan(at)highrise(dot)ca>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: Simplifying Text Search |
| Date: | 2007-11-14 03:34:37 |
| Message-ID: | 12778.1195011277@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> The fact that we are having this discussion at all demonstrates to me
> that we should leave well alone - any use of LIKE in this context is
> just about guaranteed to cause massive confusion.
Also, the semantics of LIKE are perfectly clearly specified by the SQL
standard; unless you're willing to ignore the spec, it's simply not
that useful for full-text search. Therefore, we have to tell people
to use some other API anyway. The existing tsearch2 API at least has
the virtue of having been proven in the field over several years.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-11-14 03:50:41 | Re: a tsearch2 (8.2.4) dictionary that only filters out stopwords |
| Previous Message | Andrew Dunstan | 2007-11-14 03:03:40 | Re: [HACKERS] plperl and regexps with accented characters - incompatible? |