Bruce Momjian wrote:
> I an attempt to communicate what full text search does, and what
> features we are thinking of adding/removing, I have put up the
> introduction in HTML:
>
> http://momjian.us/expire/fulltext/HTML/fulltext-intro.html
>
Very good idea, Bruce!
After reading the discussion and the introduction, here is what I think
tsearch in core should at least accomplish in 8.3. Please bear in mind,
that (a) I am talking from a user perspective (there might be technical
arguments against my thoughts) and (b) I have no hands-on experience
with Tsearch2 yet, so more experienced users might have different needs.
- Basic full text search usable for non-superusers - Out-of-the-box working configuration for as many languages as
reasonable(Teodor named quite a number of languages working as-is, so this is really an improvement over contrib,
great!)- No foot-guns accessible to non-superuser - Agreement on function names, perhaps some should be changed. For
instanceto_tsquery() and plainto_tsquery() seem rather unintuitive because they don't have a common prefix, and they
arenot consistent about using underscores. Perhaps to_tsquery() and to_tsquery_plain()? - Future compatibility for
allfeatures available to non-superusers - Stop words in tables, not in external files. - At least for superusers, all
featuresavailable in contrib now, should be available, too (don't know about pg_dump).
What I don't really like is the number of commands introduced without
any strong reference to full text search. E.g. CREATE CONFIGURATION
gives no hint at all that this is about full text search. IMHO there are
more configurations than just full text ones. :-) So perhaps better
spell this CREATE FULLTEXT CONFIGURATION etc.? (Think about tab
completion in psql, for instance.)
I guess this is in line with what Tom said about mapping objects and
CREATE ATTRIBUTE vs. CREATE/ALTER CONFIGURATION.
(http://archives.postgresql.org/pgsql-hackers/2007-06/msg00522.php)
After all, I would really welcome having full text search capabilities
in core.
Best Regards
Michael Paesold