Re: Updated tsearch documentation
От | Oleg Bartunov |
---|---|
Тема | Re: Updated tsearch documentation |
Дата | |
Msg-id | Pine.LNX.4.64.0707250938530.18739@sn.sai.msu.ru обсуждение исходный текст |
Ответ на | Re: Updated tsearch documentation (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: Updated tsearch documentation
|
Список | pgsql-hackers |
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. 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
В списке pgsql-hackers по дате отправления: