changing text search treatment of puncutation - Mailing list pgsql-general

From John DeSoi
Subject changing text search treatment of puncutation
Date
Msg-id 48446333-3ACA-4AAB-8ACB-AEBE17D767E3@pgedit.com
Whole thread Raw
Responses Re: changing text search treatment of puncutation
List pgsql-general
Text with the '/' character gets treated as a file path, e.g.

select * from to_tsvector('english', 'home/work');

gives only the single token:

'home/work':1

Changing '/' to '-' gives

'home':2 'work':3 'home-work':1

which is much more desirable for this application.

Is there an easy way to change '/' to be treated like '-' ? I've
looked over the documentation several times and could not find
anything. Even just a way to get the two tokens 'home' and 'work'
without the joined form would be helpful.

Thanks,


John DeSoi, Ph.D.





pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Next
From: Zbigniew Baniewski
Date:
Subject: SET CLIENT_ENCODING