Hi, In a recent linux magazine article (http://www.linux-mag.com/id/5679) there was a mentioning of Full-Text Search Integration. Which I know nothing about, but sounded interesting to me. You might want to check it out.
Regards, Tena Sakai [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] on behalf of Andreas Sent: Tue 4/15/2008 8:15 PM To: pgsql-sql@postgresql.org Subject: [SQL] How to find double entries Hi, how can I find double entries in varchar columns where the content is not 100% identical because of a spelling error or the person considered it "looked nicer" that way? I'd like to identify and then merge records of e.g. 'google', 'gogle', 'guugle' Then I want to match abbrevations like 'A-Company Ltd.', 'a company ltd.', 'A-Company Limited' Is there a way to do this? It would be OK just to list candidats up to be manually checked afterwards. Regards Andreas -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql