Re: Fixing geometic calculation - Mailing list pgsql-hackers

From Paul Matthews
Subject Re: Fixing geometic calculation
Date
Msg-id 4A7CF395.4090504@netspace.net.au
Whole thread Raw
In response to Re: Fixing geometic calculation  (Paul Matthews <plm@netspace.net.au>)
List pgsql-hackers
Paul Matthews wrote:
>   EPSILON in postgres is 1.0E-06
>   EPSILON for floats is 1.19209e-07
>   EPSILON for doubles is 2.22045E-016
>   
Bad form to reply to my own post and all. If EPSILON for double
represented 1mm, then postgres is rounding to the nearest 10,000,000 km.
Since its only about 380,000 km to the moon it's a good thing <diety of
choice> does not use postgres.


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: hot standby - merged up to CVS HEAD
Next
From: Bruce Momjian
Date:
Subject: Re: Alpha releases: How to tag