Re: Making small bits of code available

/contrib/earthdistance already exists.  Is this new functionality?

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

Bruno Wolff III wrote:
> I have some sql to define some functions for doing conversions between
> cube and latitude and longitude (as float8) and for calculating
> great circle distances between cubes (using a spherical model of the earth).
> I am not sure the code is suitable for contrib.
> The code picks a radius of the earth in meters. Other people may choose to
> use different units or even use a different radius in meters.
> I have grants in the code to make the cube functions and the functions
> defined by the script as execute for public. (The cube stuff needs to be
> done as postgres since a type is created, but then the functions aren't
> generally accessible by default.)
> The script is about 5K.
> Some people might find this useful as there are some advantages to keeping
> track of locations on the earth using cube (with 3D coordinates) as opposed
> to using point (with 2D coordinates).
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  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