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@gmail.com> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>