Values need to be quoted, I believe. Compare these two queries: Content LIKE foo.com Content LIKE 'foo.com'
I wonder whether wildcards might be necessary, like they seem to be in regular SQL: Content LIKE '%foo.com%' On 09/08/2014 12:36 am, "Jeff Blaine" <[email protected]> wrote: > Setup: RT 4.2.5 with PostgreSQL and full-text indexing enabled > and completed for all tickets. Tickets 1, 2, and 3 all have > contents with the string foo.com > > Searching for 'content LIKE foo.com' returns tickets 1, 2, 3 > > Searching for 'content NOT LIKE foo.com' returns tickets 1, 2, 3 > > Has anyone seen this? Any ideas what might be going wrong or how > do start debugging this? > > -- > Jeff Blaine > kickflop.net > PGP/GnuPG Key ID: 0x0C8EDD02 > -- > RT Training - Boston, September 9-10 > http://bestpractical.com/training >
-- RT Training - Boston, September 9-10 http://bestpractical.com/training
