Skip site navigation (1) Skip section navigation (2)

dot to be considered as a word delimiter?

From: Sushant Sinha <sushant354(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: shamnad(at)gmail(dot)com
Subject: dot to be considered as a word delimiter?
Date: 2009-05-30 05:59:29
Message-ID: 1243663169.12123.244.camel@dragflick (view raw or flat)
Thread:
Lists: pgsql-hackers
Currently it seems like that dot is not considered as a word delimiter
by the english parser.

lawdb=# select to_tsvector('english', 'Mr.J.Sai Deepak');
       to_tsvector       
-------------------------
 'deepak':2 'mr.j.sai':1
(1 row)

So the word obtained is "mr.j.sai" rather than three words "mr", "j",
"sai"

It does it correctly if there is space in between, as space is
definitely a word delimiter.

lawdb=# select to_tsvector('english', 'Mr. J. Sai Deepak');
           to_tsvector           
---------------------------------
 'j':2 'mr':1 'sai':3 'deepak':4
(1 row)


I think that dot should be considered by as a word delimiter because
when dot is not followed by a space, most of the time it is an error in
typing. Beside they are not many valid english words that have dot in
between.

-Sushant.


Responses

pgsql-hackers by date

Next:From: David E. WheelerDate: 2009-05-30 06:19:00
Subject: Re: search_path improvements WAS: search_path vs extensions
Previous:From: Robert HaasDate: 2009-05-30 03:48:54
Subject: explan refactoring

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group