[postgis-users] degrees between points

[Nicholas Lan]

Hello,

 

I'm a newbie and have been trying to find the degrees between points on a
sphere. From reading the documentation I have a table with column named
"4326" of srid 4326.

 

I insert into this column a point, Geomfromtext(POINT(0 0), 4326)

 

And then doing 

 

select ST_DISTANCE("4326",Geomfromtext('POINT(90 90)', 4326)) as dist from
test3;

 

I expected to see 90 but got 127. What am I doing wrong? Sorry if this is a
stupid question.

 

Regards

Nicholas Lan

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080116/d9a400d6/attachment.html>