CSN wrote:
> I looked through the docs and contrib, but didn't see
> anything related to storing and using latitude and
> longitude values. I have data in the form of 12° 34'
> N, 12° 34' W.
>
> Would any of the geometric data types work well for
> this type of data? Or just convert them to decimals?
> Are there any functions for converting lat/long
> to/from decimals/DDMMSS NSEW?
>
> Thanks
>
Have a look at pgSphere
http://gborg.postgresql.org/project/pgsphere/projdisplay.php
It has no release yet, but I want to do it this summer.
Check it out and send me possible bug reports.
Regards,
Janko Richter