Re: Updated tsearch documentation - Mailing list pgsql-hackers
From | Bruce Momjian |
---|---|
Subject | Re: Updated tsearch documentation |
Date | |
Msg-id | 200707261956.l6QJuh217122@momjian.us Whole thread Raw |
In response to | Re: Updated tsearch documentation (Oleg Bartunov <oleg@sai.msu.su>) |
Responses |
Re: Updated tsearch documentation
|
List | pgsql-hackers |
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 --------------------------------------------------------------------------- > > 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 -- 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: