From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
---|---|
To: | Scott Holmes <sholmes(at)pacificnet(dot)net> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need help with attributes... |
Date: | 2000-05-02 20:20:40 |
Message-ID: | 390F3898.27F8A25D@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Scott Holmes wrote:
>
> I created a latitude/longitude function (it's Richard Lynch's, actually)
> that returns the distance between to points. What I don't know how to do
> is use this value as a filter in the select statement:
>
> PostgreSQL Error: 1 (ERROR: Attribute 'distance' not found )
> select distinct zip_code, gpsdistance(34.2865, 118.435, latitude,
> longitude) as distance from zipcodes where distance
> <= 10.0
>
> The value for distance is actually available, however:
>
>
> select distinct zip_code, gpsdistance(34.2865, 118.435, latitude,
> longitude) as distance from zipcodes where zip_code
> like '913%'
>
> 91301 16.3049416821461,
> 91302 12.858968990111,
> 91303 8.71667347958831,
> 91304 8.67013652211651,
> 91305 8.45399567001425,
> 91306 .....
>
> Any assistance on this question of syntax would be gratefully accepted
Double-quote distance to make it an alias rather than a column name. Then,
I'm not sure you can use the double-quoted version in the where clause or
not...
Regards,
Ed Loehr
From | Date | Subject | |
---|---|---|---|
Next Message | surfer girl | 2000-05-02 21:00:15 | OID output problems |
Previous Message | Scott Holmes | 2000-05-02 19:48:26 | Need help with attributes... |