Re: full text search and ILIKE type clauses. - Mailing list pgsql-general

From Tim Uckun
Subject Re: full text search and ILIKE type clauses.
Date
Msg-id CAGuHJrMohOyTJ51xJ=7TX4nZ3Vk8cWQ-PbEqomiAOcYmPvAQGg@mail.gmail.com
Whole thread Raw
In response to Re: full text search and ILIKE type clauses.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>
> If you're using 9.1, you might look into contrib/pg_trgm instead.


If I was to use trgm would it be better to create a trigram index on
each text field? In the past I have created a text field which
contains the rest of the fields concatenated. That works great as long
as you are looking for any word. Is  there a way to specify which word
should match?  Could I combine hstore and tgm to match against
individual words?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: full text search and ILIKE type clauses.
Next
From: Aleksey Tsalolikhin
Date:
Subject: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?