Hello, Probably the simplest way is to use built-in point type and GiST index over box(point, point). You will be able to make flat geometrical calculations (e.g. distance with <-> operator) and retrieve data in the box given with index support. Regards, Ivan On Thu, Jul 10, 2008 at 9:25 PM, mark <markkicks@xxxxxxxxx> wrote: > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
