Sorry I'm not of much help but...
did you check the data types page?
http://postgresql.mirrors-r-us.net/docs/8.2/interactive/datatype-geometric.htmlhttp://postgresql.mirrors-r-us.net/docs/8.2/interactive/datatype-numeric.html
That mainly depends on how many digits you need to store, if that'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: markkicks@gmail.com
> 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 changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
_________________________________________________________________
Juega y gana, tenemos 3 Xbox a la semana.
http://club.prodigymsn.com/
