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

From Thomas G. Lockhart
Subject Re: [HACKERS] Postgres Geo Data Types
Date
Msg-id d53f14f97867e2970e47797c37380731
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: ycourties@internet.ubisoft.fr (Yann Courties)
Date:
Subject: [HACKERS] Problems with Large Objects !!
Next
From: Fabrizio Sciarra
Date:
Subject: [HACKERS] Postgres Geo Data Types