| 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: | Whole Thread | Raw Message | 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. +
| 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 |
| 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? |