Re: Metaphone function attachment

From: Joel Burton <jburton(at)scw(dot)org>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Metaphone function attachment
Date: 2001-05-04 16:36:18
Message-ID: Pine.LNX.4.21.0105041230380.29231-100000@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Why not start a new project at greatbridge.org?

I'd be happy to see metaphone() move in there, soundex() would make
sense. I have a hashing algorithm that grabs the first letter off of
words, except for user-definable 'stop words', which we use to look for
likely organization name matches.

These could all fall under a project of PG string functions.

I think, as little things in contrib/, it's easy for people to miss
these. With a project page, some discussion, etc. (& a place in contrib/),
more people would be able to use these.

PG functions are one of the things that separates PG from MySQL (which has
only C UDFs, and IIRC, not on some platforms) and InterBase (which has
plsql-like procedures, but functions can only be written in C). I think
our functions are one of our strongest cases, and the more we can show
people examples of how to use them, and the larger our useful library, the
more we win.

P.S. What exactly does contains() do?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message newsreader 2001-05-04 16:40:04 Re: a primer on trigger?
Previous Message Bruce Momjian 2001-05-04 16:29:05 Re: Ideal hardware configuration for pgsql

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-05-04 16:36:23 Re: Re: New Linux xfs/reiser file systems
Previous Message Tony Grant 2001-05-04 16:29:57 Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?