Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 71C894762A0 for ; Wed, 5 Jun 2002 14:41:22 -0400 (EDT) Received: from jalapeno.crazydogs.org (unknown [212.78.70.100]) by postgresql.org (Postfix) with ESMTP id CD039475E25 for ; Wed, 5 Jun 2002 14:40:00 -0400 (EDT) Received: from rp by jalapeno.crazydogs.org with local (Exim 3.35 #1 (Debian)) id 17FfhG-0004En-00 for ; Wed, 05 Jun 2002 19:39:50 +0100 Date: Wed, 5 Jun 2002 19:39:50 +0100 From: Richard Poole To: pgsql-sql@postgresql.org Subject: Re: Indexing Metaphone? Message-ID: <20020605183950.GA25470@guests.deus.net> References: <200206051112.02090.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200206051112.02090.josh@agliodbs.com> User-Agent: Mutt/1.3.28i X-Archive-Number: 200206/42 X-Sequence-Number: 8007 On Wed, Jun 05, 2002 at 11:12:02AM -0700, Josh Berkus wrote: > jwnet=> CREATE INDEX idx_locations_metaphone ON > locations(metaphone(location_name, 12)); > ERROR: parser: parse error at or near "12" > jwnet=> > > is this a syntax error, or do I need to create a column to hold the metaphone > values in order to index them? That's the error message you'd get if pg just didn't know of any function called "metaphone". Have you done the appropriate CREATE FUNCTION magic? "\df metaphone" in psql will tell you whether it's heard of it or not. Richard