Hi,
I am trying to find the longest line of a polygon and insert it into a new
line. I can create the makeline as in the code below but cannot create a
new layer out of it using the INTO keyword. Any help would be appreciated.
Thanks
SELECT
ST_MakeLine(St_LongestLine(
(SELECT geom FROM floodplainw
WHERE id = 1),
(SELECT geom FROM floodplainw
WHERE id = 1))
);
Le gach dea ghui,
*Shane Carey*
*GIS and Data Solutions Consultant*
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
