searching through a catalogue with tsearch2 (examples, references, HOWTO)

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: searching through a catalogue with tsearch2 (examples, references, HOWTO)
Date: 2008-10-17 11:26:14
Message-ID: 20081017132614.42d92f2d@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to learn more about how to use tsearch2 to build up a SE for
a catalogue (product name, manufacturer, category etc...).

I'm facing problems like how to implement an advanced search vs.
simple search.
eg.

1)
select * from doc where vector @@ to_tsquery('car:A | fast:B |
joy:C')

vs.

search into title, body and authors "car fast joy"
select * from doc where vector @@ to_tsquery('car | fast | joy')

where car, fast and joy comes from different fields.

vs.

multiple tsvector/indexes for each field

2) how to exploit rank functions etc...

3) how to flatten accents papà=papa

etc...

Other than the author's website and postgresql manual could someone
point me to some good documentation, howto, examples?
I'd appreciate even some general introduction to SE for catalogues
that could be applied to tsearch2.

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Browse pgsql-general by date

  From Date Subject
Next Message Mikkel Høgh 2008-10-17 11:48:11 Re: Annoying Reply-To
Previous Message Bill Moran 2008-10-17 11:20:17 Re: Annoying Reply-To