From: PFC <lists@boutiquenumerique.com>
To: Bill Lawrence <bill.lawrence@cox.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Rod Taylor <pg@rbt.ca>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Getting the output of a function used in a where clause
Date: Tue, 19 Apr 2005 09:44:01 +0200
Message-ID: <op.spgyfndzth1vuj@localhost> (raw)
In-Reply-To: <NEBBJBFOALCOMIDOAMHCMEOMDAAA.bill.lawrence@cox.net>
References: <NEBBJBFOALCOMIDOAMHCMEOMDAAA.bill.lawrence@cox.net>
> 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 ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lists@boutiquenumerique.com, bill.lawrence@cox.net, tgl@sss.pgh.pa.us, pg@rbt.ca, smarlowe@g2switchworks.com
Subject: Re: Getting the output of a function used in a where clause
In-Reply-To: <op.spgyfndzth1vuj@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox