[GENERAL] Data type to store latitude and longitude

2005-07-11 Thread MaRCeLO PeReiRA
Hi guys, Is there a data type to store data extracted from a GPS? The only thing I need is store latitude and longitude. Thanks in advance, Regards, Marcelo P Campinas/SP/Brazil ___ Yahoo! Acesso GrĂ¡tis -

Re: [GENERAL] Data type to store latitude and longitude

2005-07-14 Thread woodb
> Hi guys, > > Is there a data type to store data extracted from a > GPS? The only thing I need is store latitude and > longitude. > > Thanks in advance, > There are a few options, Using basic Postgresql: store the lats as +-90 & longs as 0-360 or +-180 numeric datatypes. create a numeric array

Re: [GENERAL] Data type to store latitude and longitude

2005-07-11 Thread Tom Lane
MaRCeLO PeReiRA <[EMAIL PROTECTED]> writes: > Is there a data type to store data extracted from a > GPS? The only thing I need is store latitude and > longitude. You might be interested in postgis http://www.postgis.org/ regards, tom lane ---(end o