[rt-users] '.' as delimiter/boundary breaks domain name searches

Kevin Falcone falcone at bestpractical.com
Thu Oct 2 10:56:56 EDT 2014


On Wed, Oct 01, 2014 at 03:50:43PM -0400, Jeff Blaine wrote:
> [ Similar, but unrelated to my other message from 10 minutes ago. ]
> 
> It appears any '.' is interpreted as a word boundary with
> Pg full-text indexing turned on.
> 
> Is that known to be true, or am I wrong?
> 
> This breaks searches for FQDNs names in ticket contents.
> 
> Searching for 'foobar' will hit foobar.org
> 
> Searching for 'foobar.org' will not hit 'foobar.org'

What FTS will match/return is dictated by your database and its
configuration.

Have you reviewed the Postgres full text search documentation for your
release of Pg?

http://www.postgresql.org/docs/8.4/static/textsearch.html

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 221 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20141002/da84ee77/attachment.sig>


More information about the rt-users mailing list