Re: Updated tsearch documentation

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
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-19 03:27:59
Message-ID: 200707190327.l6J3Rxf15201@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

Oleg, Teodor,

I am confused by the following example. How does gin know to create a
tsvector, or does it? Does gist know too?

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

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

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));

--
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. +

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Oleg Bartunov 2007-07-19 04:59:06 Re: Updated tsearch documentation
Previous Message Chris Browne 2007-07-19 01:46:12 Florida Linux Conference

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2007-07-19 04:59:06 Re: Updated tsearch documentation
Previous Message Tom Lane 2007-07-19 00:19:55 Re: Why so many out-of-disk-space failures on buildfarm machines?