Re: Getting the output of a function used in a where clause

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Bill Lawrence" <bill(dot)lawrence(at)cox(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Rod Taylor" <pg(at)rbt(dot)ca>
Cc: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting the output of a function used in a where clause
Date: 2005-04-19 07:44:01
Message-ID: op.spgyfndzth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> Thanks Tom and Rod.
>
> There are indeed several additional conditions on the "real" query which
> prune the search space (I formulate a quick search box and filter on
> Lat/Lon's within the box). Since my user interface limits the search to
> a 30
> mile radius, there are at most 81 results (in New York city, far fewer,
> for

Why don't you use a GiST index which will index this bounding box search ?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message etur 2005-04-19 08:50:40 select the last post
Previous Message sreejith s 2005-04-19 07:37:07 "Money" Data Type Problem