On 02/28/2013 06:12 PM, John R Pierce wrote: > On 2/27/2013 10:35 PM, Ghislain Hachey wrote: >> I have a varchar column with content such as "Client Name - Brief >> Description of Problem" (it's a help desk ticket system). I want to >> generate reports by clients and the only thing I can base my query on >> is this column. The client names often contain typos or are entered >> slightly differently. I installed the pg_trgm extension and it almost >> does what I want. The problem is that it searches the similarity of >> the whole field and not just the client name resulting in not so >> similar searches (I include my query below). > > > why isn't client name a separate field?? thats the logical approach
I know, but the system and the workflow of the staff is already in place. I was hoping to get something quick with minimal changes. I was also hoping to understand more how wildcards can be used with pg_trgm. Otherwise, I will add a field and modify the app. Thanks, -- GH<www.ghachey.info>
