[postgis-users] problem with the_geom returned by ST_Line_Substring

[Worth Lutz]

Postgis 1.5.3

I'm having a problem with the output of ST_Line_Substring().

Mapserver will not display the results when I replace the original geom with
the substring.  The geometry is there but when trying to look at it I see
some anomalies. I have noticed that when I look at the results with
ST_AsText:

ST_AsText(the_geom) returns:

    MULTILINESTRING((2109131.635 773598.026, ...


ST_AsText(ST_Line_Substring(the_geom, 0, 0.5))  returns:

    MULTILINESTRING(SRID=2264;(2109131.635 773598.026, ...


I do not know if that is a clue to the problem.

Also:

ST_AsEWKT(the_geom) returns:

    SRID=2264;MULTILINESTRING((2109131.635 773598.026, ...

ST_AsEWKT(ST_Line_Substring(the_geom, 0, 0.5)) returns:

    SRID=2264;MULTILINESTRING(SRID=2264;(2109131.635 773598.026, ...