, Thanks for all the great advice!
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, April 18, 2005 8:00 PM
To: Rod Taylor
Cc: Bill Lawrence; Scott Marlowe; PFC; pgsql-sql@postgresql.org
Subject: Re: [SQL] Getting the output of a function used in a where clause
Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 12, 2005 6:55 AM
To: Bill Lawrence
Cc: PFC; pgsql-sql@postgresql.org
Subject: Re: [SQL] Getting the output of a function used in a where clause
Why not just do:
SELECT zipcode, zipdist($lat1d,$lon1d,lat,long) as distance from
zipcodes where
Thanks a bunch!
Looks pretty step-by-step at the site for the link you sent. I'll give it a
shot and see how it turns out.
Thanks again for all your help!
Bill
-Original Message-
From: PFC [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 12, 2005 1:03 AM
To: Bill Lawrence
Subjec
t it a lot
faster.
On Sat, 09 Apr 2005 03:43:39 +0200, Bill Lawrence <[EMAIL PROTECTED]>
wrote:
> HI,
>
> I'm a newbie so please bear with me. I have a function defined (got it
> from
> one of your threads... thanks Joe Conway) which calculates the distance
> between
HI,
I’m a newbie so please bear with me. I have a function defined (got it
from one of your threads… thanks Joe Conway) which calculates the distance between 2 zip code centeroids (in
lat,long). This thing works great. However, I want to sort my results by
distance without incurring th
