var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Incompatible arguments from ST_FindMeasure to ST_PointN
DB2 v9.5.500.784" and Fix Pack "5"
It seems, I have troubles extracting a point from multipoint geometry returned by ST_FindMeasure spatial function.
My sql clause:
SELECT ST_AsText(ST_Transform(ST_FindMeasure(shape, mp),1)) as point
returns a multipoint geometry:
MULTIPOINT (-104.971445 42.253251)
but when I want to extract a point from it:
SELECT ST_PointN(ST_Transform(ST_FindMeasure(shape, mp),1),1) as point
,I get an error of incompatible arguments:
SQL0440N No authorized routine named "ST_POINTN" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
Why ST_PointN does not return a point geometry from the result of ST_FindMeasure?
Last edited by mt11; 06-13-13 at 15:07.
Reason: added DB2 version
Tags for this Thread