Re: [HACKERS] Postgres Geo Data Types - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Postgres Geo Data Types
Date
Msg-id 6d40a66d59994cf49668d9fe198580cb
Whole thread Raw
In response to [HACKERS] Postgres Geo Data Types  (Fabrizio Sciarra <fabrizio@pisa.intecs.it>)
List pgsql-hackers
Fabrizio Sciarra wrote:
> Is there anyone using geo data types ?
> Algorithms in Postgres6.1 seems to be too unaccurate for my purposes.
> Aren't for you ? What can we do ? Any plans ?

Uh, could you please be specific? What "algorithms" are inaccurate? Most
of the code is inherited from previous versions of Postgres, but I have
done extensive work on the input/output formats, internal storage,
adding a circle data type, comparison operators, and conversion
operators between types.

Most math is double precision float, so should be fairly accurate in
principle. However, older versions of Postgres had at least some
floating point operations rounded to 7 digits for purposes of
comparisons!?! Made the regression tests and low precision work easier,
but...

            - Tom

------------------------------

pgsql-hackers by date:

Previous
From: David Friend
Date:
Subject: Re: [HACKERS] Third Party Stuff
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] 6.1 jumbo patch?