| From: | Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz> |
|---|---|
| To: | robmayfield(at)attbi(dot)com |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Full-text searching in PostgreaSQL - Using GiST for |
| Date: | 2002-01-18 23:42:59 |
| Message-ID: | 1011397379.31188.0.camel@kant.mcmillan.net.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, 2002-01-16 at 10:41, robmayfield(at)attbi(dot)com wrote:
> I have searched high and low on the Web for information on how to do create
> GiST (or any workable indexing scheme)full-text searches on medium size
> bodies of text stored in a PostGresSQL 7.1.3 'TEXT' or VARCHAR field.
> the most I find is for integers: CREATE INDEX message_rdtree_idx on message
> using gist ( sections gist__int_ops);
> Can't find any info refering to examplkes with text. I know that 7.2 has
> tsearch but that is still in beta. Anybody got an info and examples??
http://openfts.sourceforge.net/
Cheers,
Andrew.
--
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
Are you enrolled at http://schoolreunions.co.nz/ yet?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen P. Berry | 2002-01-19 00:24:33 | Functions in C with Ornate Data Structures |
| Previous Message | Tom Lane | 2002-01-18 19:26:04 | Re: pq_recvbuf: unexpected EOF on client connection |