From: b t <qtboyzz@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: How to use UDF in C
Date: Sat, 12 Feb 2005 19:39:17 -0800 (PST)
Message-ID: <20050213033917.95491.qmail@web61004.mail.yahoo.com> (raw)
First of all thanks to those who take time to reply to my message.
I have a question, as part of the project that I have to do for school, we have to implement a User Define Function in C that is similar like the LIKE funtion in PostgreSQL. For example where a customer is searching for an actor whose last name sounds like "Schwarseneger" (notice the typo). However, the customer is not sure neither about the spelling nor the pronunciation. The real star name should be "Schwarzenegger". In this case, the "LIKE" operator in SQL is not capable enough. It would be nice if the search would match last names "similar to" "Schwarseneger". Can Some one please give me some pointer on this or even sample code that you might have implemented. So basically the thing that I'm doing is like a spell check system where it return the closest match to the word.
Thanks in advance
-Brian Trinh
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: qtboyzz@yahoo.com
Subject: Re: How to use UDF in C
In-Reply-To: <20050213033917.95491.qmail@web61004.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox