Re: Updated tsearch documentation - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Updated tsearch documentation
Date
Msg-id 200707272029.l6RKT2K11886@momjian.us
Whole thread Raw
In response to Re: Updated tsearch documentation  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
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@gmail.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@sai.msu.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@sai.msu.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@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [PATCHES] allow CSV quote in NULL
Next
From: Bruce Momjian
Date:
Subject: Re: Updated tsearch documentation