Changes between Initial Version and Version 1 of Ticket #5874, comment 2


Ignore:
Timestamp:
04/02/25 22:59:55 (11 days ago)
Author:
jratike80

Legend:

Unmodified
Added
Removed
Modified

  • TabularUnified Ticket #5874, comment 2

    initial v1  
    11Originally asked on gis.stackexchange https://gis.stackexchange.com/questions/491461/st-linesubstring-returns-incorrect-lengths-in-geography-in-postgis/491468#491468.
     2
     3It seems that the problem can be simplified into question "why ST_LineSubstring with range 0,1 in the following case drops the last vertex?".
     4
     5
     6{{{
     7SELECT
     8ST_Astext(
     9ST_LineSubstring(ST_SetSRID(ST_GeomFromText('LINESTRING(2.3522 48.8566, 2.3535 48.8570, 2.3548 48.8580, 2.3561 48.8590, 2.3574 48.8600)'), 4326)
     10::geography,0,1))
     11
     12"LINESTRING(2.3522 48.8566,2.3535 48.857,2.3548 48.858,2.355442128456938 48.85849395179974)"
     13}}}