Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2011

    Question 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
    from table

    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
    from table

    ,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 16:07. Reason: added DB2 version

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts