Re: Indexing Metaphone?

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