Hi, ST_Dump returns geometry_dump object that consists of two fields. To get geometry from it:
(ST_Dump(whatever)).geom as geom чт, 18 окт. 2018 г. в 19:46, Shane Carey <[email protected]>: > Hi, > > I still dont get any GIS layers returning, when I do: > > SELECT ST_Dump(ST_Split(polygon.geom, line.geom)) > INTO clip1 > FROM testclip line, floodplainw polygon; > > > Thanks > Le gach dea ghui, > *Shane Carey* > *GIS and Data Solutions Consultant* > > > On Thu, Oct 18, 2018 at 6:00 PM Shane Carey <[email protected]> wrote: > >> Ok so! :) >> Le gach dea ghui, >> *Shane Carey* >> *GIS and Data Solutions Consultant* >> >> >> On Thu, Oct 18, 2018 at 3:45 PM Arnaud L. <[email protected]> >> wrote: >> >>> Le 18/10/2018 à 18:55, Shane Carey a écrit : >>> > Ok thanks, will do in future: >>> >>> Dont' wait, do it now ! ;) >>> >>> > This is what I have tried and no joy- any ideas? Thanks in advance. >>> > SELECT ST_AsText((ST_Dump(ST_Split(circle, line))).geom) As wkt >>> >>> Don't make a WKT representation. WKT is a text string, not a geometry. >>> Remove the ST_AsText() and you should be OK. >>> >>> -- >>> Arnaud >>> >> _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users -- Darafei Praliaskouski Support me: http://patreon.com/komzpa
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
