Thread: Earthdistance update for 7.4 - depends on recent cube patches
The attached patches change earthdistance to use the new cube functions in one of the earth functions so that latitude and longitude to cartesian coordinates conversion will be more accurrate. (Previously a text string was built to provide as input which limited the accuracy to the number of digits printed.) The new functions were included in a recent patch to contrib/cube that has not as yet been accepted as of yet. I also added check constraints to the domain 'earth' since they are now working in 7.4.
Attachment
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Bruno Wolff III wrote:
> The attached patches change earthdistance to use the new cube functions
> in one of the earth functions so that latitude and longitude to
> cartesian coordinates conversion will be more accurrate. (Previously
> a text string was built to provide as input which limited the accuracy
> to the number of digits printed.)
>
> The new functions were included in a recent patch to contrib/cube that has not
> as yet been accepted as of yet.
>
> I also added check constraints to the domain 'earth' since they are now
> working in 7.4.
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Patch applied. Thanks. --------------------------------------------------------------------------- Bruno Wolff III wrote: > The attached patches change earthdistance to use the new cube functions > in one of the earth functions so that latitude and longitude to > cartesian coordinates conversion will be more accurrate. (Previously > a text string was built to provide as input which limited the accuracy > to the number of digits printed.) > > The new functions were included in a recent patch to contrib/cube that has not > as yet been accepted as of yet. > > I also added check constraints to the domain 'earth' since they are now > working in 7.4. [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073