Postgres Pro
Downloads
Home   >   mailing lists

Full Text Search - Influenceing the creation of tsvector - Mailing list pgsql-novice

From Pauline Dubois
Subject Full Text Search - Influenceing the creation of tsvector
Date
Msg-id 706473.96479.qm@web23905.mail.ird.yahoo.com
Whole thread Raw
Responses Re: Full Text Search - Influenceing the creation of tsvector
List pgsql-novice
Tree view
Dear all,

like described in the docs i have created a separate tsvector column to hold the output of to_tsvector.
UPDATE foo_table SET textsearchable_index_col =
     to_tsvector('english', coalesce(name,'')
The problem is that i have names like  'foo-bar'.
The char '-' is a space symbol.
The tsvector lokks like:
"'bar':3 'foo':2 'foo-bar':1"

A
"SELECT *
FROM foo_table
WHERE textsearchable_index_col @@ to_tsquery('foo')"

finds now 'foo-bar', but this is not what i want because i have 'foo-bar1,foo-bar2..'. Because of performace only 'foo-bar(n)' should match.

The docs are good but a bit intimidating and i don't understand all.

Is there a way to create the tsvector lokks like:
"''foo-bar':1" so that the space symbol would be ignored?

best regards,
pauline

pgsql-novice by date:

Previous
From: Mike
Date:
Subject: Re: How to insert data from a text file
Next
From: Bruce Hyatt
Date:
Subject: Re: Yum Update Errors - SOLVED -