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
