Re: Similarity Search with Wildcards

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

--
john r pierce 37N 122W
somewhere on the middle of the left coast