[postgis-users] ST_AddPoint legacy doc error?

Charlton Galvarino charlton at 2creek.com
Mon Dec 9 11:43:10 PST 2019


Hello, PostGIS.  I have some legacy functions on my hand that I am bringing out of the Dark Ages.

Once upon a time, I needed to take advantage of the "position" parameter to explicitly indicate that I wanted to append to a linestring.

select st_astext(st_addpoint(st_makeline(st_makepoint(0, 0), st_makepoint(1, 1)), st_makepoint(2,2), -1));
        st_astext
-------------------------
 LINESTRING(0 0,1 1,2 2)

Apparently that is now the same thing had I left off the -1 completely.

select st_astext(st_addpoint(st_makeline(st_makepoint(0, 0), st_makepoint(1, 1)), st_makepoint(2,2)));
        st_astext
-------------------------
 LINESTRING(0 0,1 1,2 2)

However, if I left the -1 in there which still seems to support the current documentation, https://postgis.net/docs/ST_AddPoint.html, psql protesteth.

select st_astext(st_addpoint(st_makeline(st_makepoint(0, 0), st_makepoint(1, 1)), st_makepoint(2,2), -1));
ERROR:  Invalid offset

Perhaps the doc should drop the -1, too?




Charlton Galvarino
1 (803) 233-6205 : voice
1 (803) 223-9579 : fax
charlton at 2creek.com
 
P.O. Box 50960
Columbia, SC 29250



More information about the postgis-users mailing list