Could you please tell me the sql query for the following case. I have a polygon which has id,name,latitude and longitude. I used the query: select ASTEXT(polygon) AS polygon from table_name; This gives me all details but are congested. How can I seperate them?
The result is just a string so there are lots of ways to "parse" it. Can you describe what you want to do with the result? Or how you want to separate the result?
Polygon query
Posted - 06/04/2012 : 06:45:53
