Postgres Pro
Downloads
Home   >   mailing lists

Re: Best Fit SQL query statement - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: Best Fit SQL query statement
Date
Msg-id a55915760708101813u5e5aab6cv198f7c7348083a95@mail.gmail.com
Whole thread Raw
In response to Re: Best Fit SQL query statement  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Best Fit SQL query statement  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-sql
Tree view 
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 || '%';

pgsql-sql by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Best Fit SQL query statement
Next
From: "Javier Fonseca V."
Date:
Subject: Trigger Procedure Error: NEW used in query that is not in a rule