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.html http://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@xxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > 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/
