Hi All-
I wanted to try the Spheroid distance function on some choice city
centroids..
but, the query is not working
geometry_columns says: t
f_table_name worldcities ; the_geom | 2 | 4326 | POINT
I can say for example
select the-geom from worldcties where city = 'fresno' and region =
'ca';
but, when I combine it as in
select st_distancespphere(
(select the-geom from worldcities where city = 'fresno' and region =
'ca'),
(select the-geom from worldcities where city = 'chico' and region =
'ca') );
error; function st_distancesphere(geometry, geometry) does not exist
adding a cast to type ::POINT says
cannot caste type geometry to point
what am I missing?
thanks
-Brian
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
