Thread: ordering op for WHERE

hi,

does it make sense to teach the planner (and the executor?) use an ordering op
to optimize queries like the following?
select * from t where a <-> 1000 < 10

YAMAMOTO Takashi

On Tue, Dec 27, 2011 at 10:48 PM, YAMAMOTO Takashi
<yamt@mwd.biglobe.ne.jp> wrote:
> does it make sense to teach the planner (and the executor?) use an ordering op
> to optimize queries like the following?
>
>        select * from t where a <-> 1000 < 10

Seems useful to me.  I'm not sure how hard it is, though.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company