Funny, just today I was thinking "Hmm, a DMS data type might be useful to
implement."
Right now there is no such thing (in the official sources anyway). Unless
you want to walk the long path of making up your own datatype (which we'd
appreciate, of course), you might be better off creating a conversion
function or two in the backend or letting the frontend handle the
conversion.
(Of course, if you do create conversion functions in the backend, you are
already half-way to having your own datatype.)
On second thought, perhaps you could abuse the time datatype. Of course
it's more like HMS, but perhaps you could make a spin off.
-Peter
On Sat, 13 Nov 1999 vandewal@dhc.net wrote:
> Hey,
>
> I am builing a system that is going to be dealing with a large
> amount of GIS (geographic) data from USGS. Some of their data
> provides lattitude and longitude in the DMS (degrees minnutes seconds)
> format, other provides lat/lon in decimal format. The decimal is
> obviously not a problem for postgres, but the DMS is. I am going to
> need to be doing queries based on the DMS data, and will need it
> treated as numeric instead of just a text string.
>
> Soooo (to get to my question already!) what I want to know is
> whether anyone else has already coded up a data type to do this
> kind of thing or whether I just have to do it myself.
>
> I search around but didn't find one.
>
> Thanks for you time.
>
> dv
>
>
> // David E. Vandewalle | The best diplomat I know is a fully
> // vandewal@skyblue.com | activated phaser bank.
> // david.e.vandewalle@lmco.com | -- Scotty
>
> ************
>
>
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden