Re: Updated tsearch documentation

Thanks, I found a few more places that needed updating. It should be
accurate now. Thanks for the report.

---------------------------------------------------------------------------

Oleg Bartunov wrote:
> On Thu, 26 Jul 2007, Bruce Momjian wrote:
>
> > Oleg Bartunov wrote:
> >> Bruce,
> >>
> >> I sent you link to my wiki page with summary of changes
> >> http://www.sai.msu.su/~megera/wiki/ts_changes
> >>
> >> Your documentation looks rather old.
> >
> > I have updated it to reflect your changes:
> >
> > http://momjian.us/expire/fulltext/HTML/textsearch-tables.html
>
>
> Bruce, I noticed you miss many changes. For example,
>
>
> options for stemmer has changed (it's documented in my ts_changes),
> so in
> http://momjian.us/expire/fulltext/HTML/textsearch-tables.html#TEXTSEARCH-TABLES-CONFIGURATION
>
> ALTER TEXT SEARCH DICTIONARY en_stem SET OPTION 'english-utf8.stop';
>
> should be
>
>
> ALTER TEXT SEARCH DICTIONARY en_stem SET OPTION
> 'StopFile=english-utf8.stop, Language=english';
>
>
> Also, this is wrong
>
> DROP TEXT SEARCH CONFIGURATION MAPPING ON pg FOR email, url, sfloat, uri, float;
>
> it should be
>
> ALTER TEXT SEARCH CONFIGURATION pg DROP MAPPING FOR email, url, sfloat, uri, float;
>
> Configuration now doesn't have DEFAULT flag, so \dF should not display 'Y'
>
>
> => \dF
> pg_catalog | russian | Y
> public | pg | Y
>
>
> This is what I see now
>
> postgres=# \dF public.*
> List of fulltext configurations
> Schema | Name | Description
> --------+------+-------------
> public | pg |
>
>
>
> >
> > ---------------------------------------------------------------------------
> >
> >
> >>
> >> Oleg
> >> On Tue, 24 Jul 2007, Bruce Momjian wrote:
> >>
> >>>
> >>> I have added more documentation to try to show how full text search is
> >>> used by user tables. I think this the documentaiton is almost done:
> >>>
> >>> http://momjian.us/expire/fulltext/HTML/textsearch-tables.html
> >>>
> >>> ---------------------------------------------------------------------------
> >>>
> >>> Oleg Bartunov wrote:
> >>>> On Wed, 18 Jul 2007, Bruce Momjian wrote:
> >>>>
> >>>>> Oleg, Teodor,
> >>>>>
> >>>>> I am confused by the following example. How does gin know to create a
> >>>>> tsvector, or does it? Does gist know too?
> >>>>
> >>>> No, gist doesn't know. I don't remember why, Teodor ?
> >>>>
> >>>> For GIN see http://archives.postgresql.org/pgsql-hackers/2007-05/msg00625.php
> >>>> for discussion
> >>>>
> >>>>>
> >>>>> FYI, at some point we need to chat via instant messenger or IRC to
> >>>>> discuss the open items. My chat information is here:
> >>>>>
> >>>>> http://momjian.us/main/contact.html
> >>>>
> >>>> I send you invitation for google talk, I use only chat in gmail.
> >>>> My gmail account is obartunov(at)gmail(dot)com
> >>>>
> >>>>>
> >>>>> ---------------------------------------------------------------------------
> >>>>>
> >>>>> SELECT title
> >>>>> FROM pgweb
> >>>>> WHERE textcat(title,body) @@ plainto_tsquery('create table')
> >>>>> ORDER BY dlm DESC LIMIT 10;
> >>>>>
> >>>>> CREATE INDEX pgweb_idx ON pgweb USING gin(textcat(title,body));
> >>>>>
> >>>>>
> >>>>
> >>>> Regards,
> >>>> Oleg
> >>>> _____________________________________________________________
> >>>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> >>>> Sternberg Astronomical Institute, Moscow University, Russia
> >>>> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> >>>> phone: +007(495)939-16-83, +007(495)939-23-83
> >>>
> >>>
> >>
> >> Regards,
> >> Oleg
> >> _____________________________________________________________
> >> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> >> Sternberg Astronomical Institute, Moscow University, Russia
> >> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> >> phone: +007(495)939-16-83, +007(495)939-23-83
> >
> >
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +