Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1go9Wt-0000kq-Pm for pgsql-docs@arkaria.postgresql.org; Mon, 28 Jan 2019 16:12:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1go9Ws-00079s-CU for pgsql-docs@arkaria.postgresql.org; Mon, 28 Jan 2019 16:12:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1go9Ws-00079A-3o for pgsql-docs@lists.postgresql.org; Mon, 28 Jan 2019 16:12:58 +0000 Received: from [59.5.211.76] (helo=postgresql.kr) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1go9Wo-0007kD-Fr for pgsql-docs@lists.postgresql.org; Mon, 28 Jan 2019 16:12:56 +0000 Received: by postgresql.kr (Postfix, from userid 1003) id 235A161411; Tue, 29 Jan 2019 01:12:50 +0900 (KST) Date: Tue, 29 Jan 2019 01:12:49 +0900 From: Ioseph Kim To: pgsql-docs@lists.postgresql.org Subject: patch earthdistance.sgml (add geo_distance function description) Message-ID: <20190128161249.o6zzkwcwc22aexp7@postgresql.kr> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: NeoMutt/20170113 (1.7.2) X-Host-Lookup-Failed: Reverse DNS lookup failed for 59.5.211.76 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk $ diff -urN earthdistance.sgml.orig earthdistance.sgml --- earthdistance.sgml.orig 2019-01-29 00:59:46.066302968 +0900 +++ earthdistance.sgml 2019-01-29 01:07:56.814501839 +0900 @@ -120,6 +120,13 @@ + geo_distance(point, point)geo_distance + float8 + Returns distance between the points in miles on earth's surface. A + point is composed with longitude(x) and latitude(y). + + + earth_box(earth, float8)earth_box cube Returns a box suitable for an indexed search using the cube