Quang T. answered 08/07/19
GIS professional and Engineer with 5+ years of experience
SELECT ST_WITHIN(m_polygon.bounds , m_polygon.bounds ) FROM m_polygon;
Have you tried it without m_polygon for the Select? SELECT ST_WITHIN (bounds, bounds) FROM m_polygon;
Me L.I tried, it does not help. The core issue is what ST_WITHIN arguments type should be GEOMETRY. I need to convert POLYGON type into GEOMETRY. The closest function which I found is ST_GeomFromText() http://www.postgis.net/docs/ST_GeomFromText.html but I cannot figure out how to apply it to the POLYGON type which I have in my table.