X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 88DE48B9B2B for ; Sun, 13 Feb 2005 04:03:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70507-02 for ; Sun, 13 Feb 2005 04:03:01 +0000 (GMT) Received: from joeconway.com (wsip-24-249-201-67.sd.sd.cox.net [24.249.201.67]) by svr1.postgresql.org (Postfix) with ESMTP id A23C38B9CA2 for ; Sun, 13 Feb 2005 04:03:00 +0000 (GMT) Received: from [192.168.4.1] (account jconway [192.168.4.1] verified) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 2571787; Sat, 12 Feb 2005 21:03:48 -0800 Message-ID: <420ED173.6010005@joeconway.com> Date: Sat, 12 Feb 2005 20:02:59 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.3) Gecko/20040922 X-Accept-Language: en-us, en MIME-Version: 1.0 To: b t Cc: pgsql-interfaces@postgresql.org Subject: Re: How to use UDF in C References: <20050213033917.95491.qmail@web61004.mail.yahoo.com> In-Reply-To: <20050213033917.95491.qmail@web61004.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/51 X-Sequence-Number: 5296 b t wrote: > 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. See contrib/fuzzystrmatch HTH, Joe