Andrea, Are those individual records or columns in the table? Take a look at ST_MakeLine, ST_MakePolygon, ST_BuildArea
http://postgis.refractions.net/documentation/manual-svn/ST_MakeLine.html http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html http://postgis.refractions.net/documentation/manual-svn/ST_MakePolygon.html You build a line from points with ST_MakeLine and then do a ST_BuildArea or ST_MakePolygon depending on your desired effect. Leo -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Caspa Sent: Monday, June 22, 2009 10:15 AM To: [email protected] Subject: [postgis-users] build a polygon from points Hi everybody, I'm new to postgis... how can i build a polygon starting from points and not from x,y coord? i have a table built like this: point1 | point2 | point3 | point4 | polygon guess i have to use MakeLine and MakePolygon but i can't fugure out why... thanks in advance Andrea _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
