[postgis-tickets] [SCM] PostGIS branch master updated. 3.1.0rc1-10-g5e759ed
git at osgeo.org
git at osgeo.org
Wed Dec 16 19:40:45 PST 2020
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".
The branch, master has been updated
via 5e759ede6dd94e5000e69c12a93e6da29959fa55 (commit)
from 000728dfda4b2b57eda4f809b029d19e68d95001 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit 5e759ede6dd94e5000e69c12a93e6da29959fa55
Author: Martin Davis <mtnclimb at gmail.com>
Date: Wed Dec 16 19:40:39 2020 -0800
Improve doc ST_StartPoint, ST_EndPoint
diff --git a/doc/reference_accessor.xml b/doc/reference_accessor.xml
index cd3a070..17e92bb 100644
--- a/doc/reference_accessor.xml
+++ b/doc/reference_accessor.xml
@@ -722,43 +722,58 @@ SELECT ST_AsEWKT(geom) As the_geom, path
<refsection>
<title>Description</title>
- <para>Returns the last point of a LINESTRING
- as a POINT. Returns <varname>NULL</varname> if the input
- is not a LINESTRING.</para>
+ <para>Returns the last point of a <varname>LINESTRING</varname>
+ or <varname>CIRCULARLINESTRING</varname> geometry
+ as a <varname>POINT</varname>.
+ Returns <varname>NULL</varname> if the input
+ is not a <varname>LINESTRING</varname> or <varname>CIRCULARLINESTRING</varname>.</para>
<para>&sqlmm_compliant; SQL-MM 3: 7.1.4</para>
<para>&Z_support;</para>
- <!-- Optionally mention Circular String Support -->
<para>&curve_support;</para>
- <note><para>Changed: 2.0.0 no longer works with single geometry multilinestrings. In older
- versions of PostGIS -- a single line multilinestring would work happily with this
- function and return the start point. In 2.0.0 it just returns NULL like any other multilinestring.
- The older behavior was an undocumented feature, but people who assumed they had their data stored as LINESTRING
- may experience these returning NULL in 2.0 now.</para></note>
+
+ <note><para>Changed: 2.0.0 no longer works with single geometry MultiLineStrings. In older
+ versions of PostGIS a single-line MultiLineString would work with this
+ function and return the end point. In 2.0.0 it returns NULL like any other MultiLineString.
+ The old behavior was an undocumented feature, but people who assumed they had their data stored as LINESTRING
+ may experience these returning NULL in 2.0.0.</para></note>
</refsection>
<refsection>
<title>Examples</title>
+<para>End point of a LineString</para>
<programlisting>postgis=# SELECT ST_AsText(ST_EndPoint('LINESTRING(1 1, 2 2, 3 3)'::geometry));
st_astext
------------
POINT(3 3)
-(1 row)
+</programlisting>
-postgis=# SELECT ST_EndPoint('POINT(1 1)'::geometry) IS NULL AS is_null;
+<para>End point of a non-LineString is NULL</para>
+<programlisting>
+SELECT ST_EndPoint('POINT(1 1)'::geometry) IS NULL AS is_null;
is_null
----------
t
-(1 row)
+</programlisting>
+<para>End point of a 3D LineString</para>
+<programlisting>
--3d endpoint
SELECT ST_AsEWKT(ST_EndPoint('LINESTRING(1 1 2, 1 2 3, 0 0 5)'));
st_asewkt
--------------
POINT(0 0 5)
-(1 row)</programlisting>
+</programlisting>
+
+<para>End point of a CircularString</para>
+<programlisting>
+SELECT ST_AsText(ST_EndPoint('CIRCULARSTRING(5 2,-3 1.999999, -2 1, -4 2, 6 3)'::geometry));
+ st_astext
+------------
+ POINT(6 3)
+</programlisting>
</refsection>
<refsection>
@@ -2554,46 +2569,52 @@ MULTIPOINT Z (30 10 4,10 30 5,40 40 6, 30 10 4)
<refsection>
<title>Description</title>
- <para>Returns the first point of a <varname>LINESTRING</varname> or <varname>CIRCULARLINESTRING</varname> geometry
- as a <varname>POINT</varname> or <varname>NULL</varname> if the input
- parameter is not a <varname>LINESTRING</varname> or <varname>CIRCULARLINESTRING</varname>.</para>
+ <para>Returns the first point of a <varname>LINESTRING</varname>
+ or <varname>CIRCULARLINESTRING</varname> geometry
+ as a <varname>POINT</varname>.
+ Returns <varname>NULL</varname> if the input
+ is not a <varname>LINESTRING</varname> or <varname>CIRCULARLINESTRING</varname>.</para>
<para>&sqlmm_compliant; SQL-MM 3: 7.1.3</para>
<para>&Z_support;</para>
- <!-- Optionally mention Circular String Support -->
<para>&curve_support;</para>
- <note><para>Changed: 2.0.0 no longer works with single geometry multilinestrings. In older
- versions of PostGIS -- a single line multilinestring would work happily with this
- function and return the start point. In 2.0.0 it just returns NULL like any other multilinestring.
- The older behavior was an undocumented feature, but people who assumed they had their data stored as LINESTRING
- may experience these returning NULL in 2.0 now.</para></note>
+
+ <note><para>Changed: 2.0.0 no longer works with single geometry MultiLineStrings. In older
+ versions of PostGIS a single-line MultiLineString would work happily with this
+ function and return the start point. In 2.0.0 it just returns NULL like any other MultiLineString.
+ The old behavior was an undocumented feature, but people who assumed they had their data stored as LINESTRING
+ may experience these returning NULL in 2.0.0.</para></note>
</refsection>
<refsection>
<title>Examples</title>
-
+<para>Start point of a LineString</para>
<programlisting>SELECT ST_AsText(ST_StartPoint('LINESTRING(0 1, 0 2)'::geometry));
st_astext
------------
POINT(0 1)
-(1 row)
+</programlisting>
+<para>Start point of a non-LineString is NULL</para>
+<programlisting>
SELECT ST_StartPoint('POINT(0 1)'::geometry) IS NULL AS is_null;
is_null
----------
t
-(1 row)
+</programlisting>
---3d line
+<para>Start point of a 3D LineString</para>
+<programlisting>
SELECT ST_AsEWKT(ST_StartPoint('LINESTRING(0 1 1, 0 2 2)'::geometry));
st_asewkt
------------
POINT(0 1 1)
-(1 row)
+</programlisting>
--- circular linestring --
-SELECT ST_AsText(ST_StartPoint('CIRCULARSTRING(5 2,-3 1.999999, -2 1, -4 2, 5 2)'::geometry));
+<para>Start point of a CircularString</para>
+<programlisting>
+SELECT ST_AsText(ST_StartPoint('CIRCULARSTRING(5 2,-3 1.999999, -2 1, -4 2, 6 3)'::geometry));
st_astext
------------
POINT(5 2)
-----------------------------------------------------------------------
Summary of changes:
doc/reference_accessor.xml | 79 +++++++++++++++++++++++++++++-----------------
1 file changed, 50 insertions(+), 29 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list