-----Original Message----- From: pgsql-general-owner@postgresql.org on behalf of Brent Wood Sent: Thu 7/10/2008 3:16 PM To: markkicks@gmail.com; pgsql-general@postgresql.org Subject: Re: [GENERAL] storing latitude and longitude
Hi Mark,
Look at Postgis, to do this properly. It adds full OGC spec support for managing spatial/querying spatial data within a Postgres database.
It is an option included with the Windows Postgres installer, but is generally extra packages under Linux.
Cheers,
Brent Wood
>>> mark <markkicks@gmail.com> 07/11/08 5:34 AM >>> hi.. i want to store latitude and longitude in a users table.. what is the best data type to use for this? i want to be able to find use this info to find users within a distance.. how do i go about doing this? thanks
