Hello ST_Collect IS an aggregate function : if you want to call with other columns you should choose an aggregate way. The question is : what do you want to collect ? Or how do you want to merge your geometries ?
If you want to keep row and col information, you may want to use st_collect() over() (take a look at window function for more information). To return only path or geometry from st_dump you can also use a syntax like (st_dump()).path or (st_dump()).geom. HTH Hugues. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of car271 Sent: Monday, September 23, 2013 12:33 PM To: [email protected] Subject: [postgis-users] Retrieve variables values from nested function Hi all, i've a function, ST_CreateFishnet, who returns 3 variables: geom, row and col. My goal is retrieve variables values "row" and "col" where ST_CreateFishnet is nested like query below: SELECT dump.geom FROM ST_Dump(ST_SetSRID(ST_Rotate((SELECT ST_Collect(cells.geom), cells.row, cells.col FROM ST_CreateFishnet(10, 20, 1.2, 0.6, 498320.705,4783932.452) AS cells), ((pi()/2) - (ST_Azimuth(ST_Point(498320.705,4783932.452), ST_Point(498344.646,4783932.501)))), 498320.705,4783932.452), 32631)) as dump. When i execute previous query, i get this error: column "cells.row" must appear in the GROUP BY clause or be used in an aggregate function. What i wrong? Regards. car271 -- View this message in context: http://postgis.17.x6.nabble.com/Retrieve-variables-values-from-nested-function-tp5004263.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
