Re: Updated tsearch documentation

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Updated tsearch documentation
Date: 2007-07-25 05:39:57
Message-ID: Pine.LNX.4.64.0707250938530.18739@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy 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(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

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Dave Page 2007-07-25 08:19:24 Re: PostgreSQL vs. MySQL: fight
Previous Message Chris Mair 2007-07-25 05:31:39 Re: PostgreSQL vs. MySQL: fight

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2007-07-25 08:39:35 Re: Updated tsearch documentation
Previous Message Bruce Momjian 2007-07-25 03:42:58 Re: Updated tsearch documentation