user-friendly search strings

From: Ben <bench(at)silentmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: user-friendly search strings
Date: 2002-10-26 16:11:44
Message-ID: Pine.LNX.4.44.0210260909380.16949-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey everybody. I'm sure most of you have had to deal with this problem at
some point, and I'd like to get an idea of a good way to handle it.

What I have is a column of strings that users will be doing substring
matching against. While an ilike clause takes care of most of my problems,
some of these strings aren't so easy for users to type - e.g. "Björk", "0°
North", "8½ Souvenirs", etc. In addition, some are ambiguous - e.g. "3 Dog
Night" vs. "Three Dog Night."

What I want is to make matching against this column to be user friendly,
so that, regardless if a user searches for "bjork" or "Björk", they match
against "Björk". I also want searches for "3 dog night" and "three dog
night" to have the same results.

I don't suppose any of you have a magic fuzzy-matching searchification
stored proc lying around?

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ottar Tornes 2002-10-26 20:27:26 PHP and PostgreSQL
Previous Message Ben 2002-10-26 16:07:08 COMMAND_OK for PL/pgSQL?