Closes Match

From: Christian Rusa <christian(at)rusa(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: Closes Match
Date: 2005-07-25 17:31:11
Message-ID: 42E521DF.4000804@rusa.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 and the documentation but found no solution.

Cheers Christian

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2005-07-25 17:49:52 Re: Closes Match
Previous Message Alvaro Herrera 2005-07-25 16:52:49 Re: update vs unique index