Full Text Search, avoiding lexemes search

From: Daniel Vázquez <daniel2d2art(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Full Text Search, avoiding lexemes search
Date: 2012-01-27 14:50:42
Message-ID: CA+KJVfzdjcmFf07HptwRpYHVXZSO7L2g9L8_HBWwYLv5D+nURA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys!

Full text search, searches by lexemes, this minds that if you are finding
for "gato" word you are really finding for {gat} lexeme.
I you construct vectors for the words "gato", "gatos", "gata", "gatas", all
have the same lexema {gat}
Then the search "gato" that is to say the search {gat} matches with all
previous vectors.

There some way (configuration, query....) to match only for "gato" and
avoid "gatos" "gata" "gatas", with FTS ??
Or match only for "gato" "gatos" buy no for "gata" "gatas"?

Tnks!

Browse pgsql-general by date

  From Date Subject
Next Message bboett 2012-01-27 15:44:55 How to typecast an integer into a timestamp?
Previous Message Daniel Vázquez 2012-01-27 14:41:38 Full Text Search, avoiding lexemes search