Re: [SQL] Best Fit SQL query statement

[Rodrigo De León]

On 8/10/07, hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote:
> unfortunatelly this query will be hard to optimize.

Uh, how about

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend