Received: from snigglefritz.expressus.com (dhcphost11.expressus.com [64.114.34.80]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBIMGa620605 for ; Mon, 18 Dec 2000 17:16:37 -0500 (EST) (envelope-from jkakar@expressus.com) Received: (from jkakar@localhost) by snigglefritz.expressus.com (8.11.1/8.11.1/Debian 8.11.0-6) id eBIMGi704155 for pgsql-sql@postgresql.org; Mon, 18 Dec 2000 14:16:44 -0800 From: jkakar@expressus.com Date: Mon, 18 Dec 2000 14:16:44 -0800 To: pgsql-sql@postgresql.org Subject: Problem with function... Message-ID: <20001218141644.A4107@expressus.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Archive-Number: 200012/201 X-Sequence-Number: 535 Hi, I hope my question is appropriate for this list. I'm trying to create a function that calculates the distance between a pair of latitude/longitude points. This is what I have: /* latlon_distance.pgsql * by Jamu Kakar , Dec 18, 2000. * * Calculates the distance between 2 lat/lon pairs. Syntax: * distance (lat1, lon1, lat2, lon2) where parameters are in decimal degrees. */ CREATE FUNCTION distance (float8, float8, float8, float8) RETURNS float8 AS ' DECLARE radius constant float8 := 6378; distance float8; lat1 ALIAS FOR $1; lon1 ALIAS FOR $2; lat2 ALIAS FOR $3; lon2 ALIAS FOR $4; BEGIN distance := radius * acos ((sin (radians (lat1)) * sin (radians (lat2))) + (cos (radians (lat1)) * cos (radians (lat2)) * cos (radians (lon1) - radians (lon2)))); RETURN ''distance''; END; ' LANGUAGE 'plpgsql'; When I try a: select distance(49.0,-122.0,50.0,-123.0) as distance; I get: ERROR: Bad float8 input format 'distance' I've tried a variety of ways of specifying the values and I've hunted through the mailing lists but haven't turned up anything useful. Any help would be appreciated. Thanks, Jamu. -- Jamu Kakar (Developer) Expressus Design Studio, Inc. jkakar@expressus.com 708-1641 Lonsdale Avenue V: (604) 988-6999 North Vancouver, BC, V7M 2J5