Skip site navigation (1) Skip section navigation (2)

Re: Question regarding contrib/fulltextindexing

From: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
To: Derek Barrett <derekbarrett(at)graffiti(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Question regarding contrib/fulltextindexing
Date: 2002-07-14 00:16:59
Message-ID: 1026605819.10875.56.camel@kant.mcmillan.net.nz (view raw or flat)
Thread:
Lists: pgsql-novice
On Sun, 2002-07-14 at 08:53, Derek Barrett wrote:
> 
> In my situation, I need to match exact words, so I've used regular expressions to search on a varchar(10000) field:
> 
> SELECT * 
> FROM table 
> WHERE description ~* ('[^a-zA-Z0-9]($keyword[$x])[^a-zA-Z0-9]');
> 
> Would this module still be useful in my situation?

I was doing word search with a modified version of the fulltextindex
code, but in the end I found it easier to write a perl program to do
build the index table - the trigger approach was more work to manage
than it seemed it should be.

Regards,
					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?


In response to

pgsql-novice by date

Next:From: Norman KhineDate: 2002-07-14 11:41:02
Subject: Multiple table insert using a CSV list as the data source
Previous:From: Derek BarrettDate: 2002-07-13 20:53:04
Subject: Question regarding contrib/fulltextindexing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group