pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedpatch earthdistance.sgml (add geo_distance function description)
2+ messages / 1 participants
[nested] [flat]
* patch earthdistance.sgml (add geo_distance function description)
@ 2019-01-28 16:12 Ioseph Kim <pgsql-kr@postgresql.kr>
2019-01-28 16:54 ` Re: patch earthdistance.sgml (add geo_distance function description) Ioseph Kim <pgsql-kr@postgresql.kr>
0 siblings, 1 reply; 2+ messages in thread
From: Ioseph Kim @ 2019-01-28 16:12 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
$ diff -urN earthdistance.sgml.orig earthdistance.sgml
inline patch 1: earthdistance.sgml (+7/-0 lines) download inline-1.patch
--- 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 @@
</entry>
</row>
<row>
+ <entry><function>geo_distance(point, point)</function><indexterm><primary>geo_distance</primary></indexterm></entry>
+ <entry><type>float8</type></entry>
+ <entry>Returns distance between the points in miles on earth's surface. A
+ point is composed with longitude(x) and latitude(y).
+ </entry>
+ </row>
+ <row>
<entry><function>earth_box(earth, float8)</function><indexterm><primary>earth_box</primary></indexterm></entry>
<entry><type>cube</type></entry>
<entry>Returns a box suitable for an indexed search using the cube
* Re: patch earthdistance.sgml (add geo_distance function description)
2019-01-28 16:12 patch earthdistance.sgml (add geo_distance function description) Ioseph Kim <pgsql-kr@postgresql.kr>
@ 2019-01-28 16:54 ` Ioseph Kim <pgsql-kr@postgresql.kr>
0 siblings, 0 replies; 2+ messages in thread
From: Ioseph Kim @ 2019-01-28 16:54 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
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 @@
> </entry>
> </row>
> <row>
> + <entry><function>geo_distance(point, point)</function><indexterm><primary>geo_distance</primary></indexterm></entry>
> + <entry><type>float8</type></entry>
> + <entry>Returns distance between the points in miles on earth's surface. A
> + point is composed with longitude(x) and latitude(y).
> + </entry>
> + </row>
> + <row>
> <entry><function>earth_box(earth, float8)</function><indexterm><primary>earth_box</primary></indexterm></entry>
> <entry><type>cube</type></entry>
> <entry>Returns a box suitable for an indexed search using the cube
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-01-28 16:54 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-28 16:12 patch earthdistance.sgml (add geo_distance function description) Ioseph Kim <pgsql-kr@postgresql.kr>
2019-01-28 16:54 ` Ioseph Kim <pgsql-kr@postgresql.kr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox