Re: Best Fit SQL query statement

On 8/10/07, hubert depesz lubaczewski <depesz@depesz.com> wrote:
> unfortunatelly this query will be hard to optimize.

Uh, how about

SELECT MAX(t1) FROM t1WHERE '9849' LIKE t1 || '%';