PostgreSQL function for haversine distance calculation, in miles

haversine.sql

-- Haversine Formula based geodistance in miles (constant is diameter of Earth in miles)
-- Based on a similar PostgreSQL function found here: https://gist.github.com/831833
-- Updated to use distance formulas found here: http://www.codecodex.com/wiki/Calculate_distance_between_two_points_on_a_globe
CREATE OR REPLACE FUNCTION public.geodistance(alat double precision, alng double precision, blat double precision, blng double precision)
  RETURNS double precision AS
$BODY$
SELECT asin(
  sqrt(
    sin(radians($3-$1)/2)^2 +
    sin(radians($4-$2)/2)^2 *
    cos(radians($1)) *
    cos(radians($3))
  )
) * 7926.3352 AS distance;
$BODY$
  LANGUAGE sql IMMUTABLE
  COST 100;

@FruitAndAShape Late to the party but Haversine requires a final multiplication by 2. 7926 is twice the radius of the earth in miles. You could switch that to 2 * 6371 = 12742 for kilometers.

@FruitAndAShape Late to the party but Haversine requires a final multiplication by 2. 7926 is twice the radius of the earth in miles. You could switch that to 2 * 6371 = 12742 for kilometers.

Thanks :)