Re: Getting the output of a function used in a where clause - Mailing list pgsql-sql

From PFC
Subject Re: Getting the output of a function used in a where clause
Date
Msg-id op.spgyfndzth1vuj@localhost
Whole thread Raw
In response to Getting the output of a function used in a where clause  ("Bill Lawrence" <bill.lawrence@cox.net>)
List 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 ?


pgsql-sql by date:

Previous
From: sreejith s
Date:
Subject: "Money" Data Type Problem
Next
From: Muhammad Nadeem Ashraf
Date:
Subject: Query about SQL in PostgreSQL