Hi:

I am setting up a full text search in postgresql and I expect some
data to look like 8746-4756 or like 876.3456.

This is what the ts vectors look like for the first sting:

SELECT to_tsvector('0594-4532');
Results: '-4532':2 '0594':

So postgresql treats this character string like a unsigned and signed
int:

In the second case, postgresql does not recognize the dot as a
delimiter...

SELECT to_tsvector('876.3456');
Results: '876.3456':1

I would really like to treat both the dot and the dash as delimiters.

Can this be configured...Any ideas??

Thanks in advance
kwill

Hi:

I sort of answered my own question...

Guess the real solution would be to customize the ts_vector function
to my liking...although for the time being I am going to trigger the
numeric data into a separate column with my delimiters before deriving
the ts_vector column for the full text index.

I guess I was still in a mssql state of mind when I asked the
question...postgresql is great!!!

Thanks, Willy

On Nov 18, 9:32*pm, Willy <kwillrichard... (AT) gmail (DOT) com> wrote: