[postgis-users] Retrieve variables values from nested function

[car271]

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.