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, ma
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,
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 <[EM
hat's not
enough you can always use the NUMERIC data type or create your own...
> Date: Thu, 10 Jul 2008 10:25:19 -0700
> From: [EMAIL PROTECTED]
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] storing latitude and longitude
>
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 c
