Storing latitude and longitude
От | Rodolfo J. Paiz |
---|---|
Тема | Storing latitude and longitude |
Дата | |
Msg-id | 1107477105.7053.15.camel@rodolfo.gt.factorrent.com обсуждение исходный текст |
Ответы |
Re: Storing latitude and longitude
Re: Storing latitude and longitude |
Список | pgsql-novice |
Hi: One of my tables will store latitude and longitude information. I've checked and I cannot see a datatype for that (which is no surprise, and no loss). However, I can think of three ways to store the data: * Array field (degrees, minutes, seconds) * Three integer fields * Three numeric fields with up to 2 decimals each Having one-second precision is good enough, so three integers will do. Of course, ideally I'd have two integers and a numeric for the seconds so I could have fractional seconds too. Between separate fields and an array, first is an array possible? Can I store that? If so, is there any performance or other benefit I should know about? Clearly this is not an important consideration (in fact I already created the table with two integers and a numeric field), but I thought I'd ask for the educational value of the discussion. Cheers, -- Rodolfo J. Paiz <rpaiz@simpaticus.com>
В списке pgsql-novice по дате отправления: