Re: [SQL] Closes Match

2005-07-25 Thread Jonathan Lam
unsubscribe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III Sent: Monday, July 25, 2005 10:50 AM To: Christian Rusa Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Closes Match On Mon, Jul 25, 2005 at 19:31:11 +0200, Christian Rusa

Re: [SQL] Closes Match

2005-07-25 Thread Bruno Wolff III
On Mon, Jul 25, 2005 at 19:31:11 +0200, Christian Rusa <[EMAIL PROTECTED]> wrote: > Hi there, > > I want to match a string against the database and get the closest > (shorter) match. > I was asking myself if its possible to realise this in SQL. > > So if the string is: > abcdefg > > And in th

[SQL] Closes Match

2005-07-25 Thread Christian Rusa
Hi there, I want to match a string against the database and get the closest (shorter) match. I was asking myself if its possible to realise this in SQL. So if the string is: abcdefg And in the database are entries like: a ab abc I just want to get back 'abc'. I looked around in the internet