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 1goAB6-0003Sn-AL for pgsql-docs@arkaria.postgresql.org; Mon, 28 Jan 2019 16:54:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goAB4-0000aW-Lk for pgsql-docs@arkaria.postgresql.org; Mon, 28 Jan 2019 16:54:30 +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 1goAB4-0000aN-Cp for pgsql-docs@lists.postgresql.org; Mon, 28 Jan 2019 16:54:30 +0000 Received: from [59.5.211.76] (helo=postgresql.kr) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goAB1-0000GK-6E for pgsql-docs@lists.postgresql.org; Mon, 28 Jan 2019 16:54:28 +0000 Received: by postgresql.kr (Postfix, from userid 1003) id CD84061411; Tue, 29 Jan 2019 01:54:24 +0900 (KST) Date: Tue, 29 Jan 2019 01:54:24 +0900 From: Ioseph Kim To: pgsql-docs@lists.postgresql.org Subject: Re: patch earthdistance.sgml (add geo_distance function description) Message-ID: <20190128165424.zdamrzhmsxakczwm@postgresql.kr> References: <20190128161249.o6zzkwcwc22aexp7@postgresql.kr> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20190128161249.o6zzkwcwc22aexp7@postgresql.kr> 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 Sorry, Ignore this patch. I was confused with cube-based distance and point-based distance. On Tue, Jan 29, 2019 at 01:12:49AM +0900, Ioseph Kim wrote: > $ 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 > >