[postgis-users] Retrieve variables values from nested function
car271
cfazio at ticonzero.net
Mon Sep 23 03:32:38 PDT 2013
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.
More information about the postgis-users
mailing list