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
pgpQNX77GM5ja.pgp
Description: PGP signature
-- RT Training November 4 & 5 Los Angeles http://bestpractical.com/training