Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    21

    Unanswered: Cast ST_GEO to BLOB

    Hi Guys,

    do you have any idea how to Cast a ST_Geometry to BLOB in Informix IDS?

    Thanks for all answers.

    Marcus

  2. #2
    Join Date
    Sep 2002
    Posts
    102
    ST_Geometry::BLOB

  3. #3
    Join Date
    Jun 2004
    Posts
    21
    You can't use the normaly CAST Syntax...

    "There is no function to convert ST_Geo to BLOB..."

  4. #4
    Join Date
    Oct 2005
    Posts
    1

    Casting ST_Geometry to BLOB

    Marcus,

    I wonder why you would want to do such a thing. I mean, you could, I suppose, but how would you interpret the BLOB once you got hold of it?

    You can access any part of the ST_Geometry from the various functions supplied with the DataBlade. For example, you can access all the vertices through ST_NumPoints, ST_NumGeometries, ST_StartPoint, ST_PointN, etc.

    If you really want a binary or text representation of the geometry, you could convert it to Well-Known Binary (WKB) with ST_AsBinary, or as Well-Known Text (WKT) with ST_AsText. You can find the format for each of these representations at the OGC website (http://www.opengeospatial.org/). Look in the appendix of the OpenGIS(c) Simple Features Implementation Specification for SQL.

    -- Frood

Posting Permissions

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