[postgis-users] Re: postgis-users Digest, Vol 63, Issue 10

[Brian Hamlin]

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