I'm just getting started on the WITH RECURSIVE function in PostGIS. I'm trying to recurse through a list of ids, passing them to through to the quadgrid function (credit goes to Mark Wynter at dimensionaledge). The quadgrid function only accepts a single geometry row as input.
The ids are returned via the query:
SELECT parent.gid FROM proc.gfn_rdsid78 parent
The ids are then called in the WHERE clause:
SELECT the_geom::geometry(Polygon, 4326) as geom FROM DE_RegularQuadGrid((SELECT child.geom FROM proc.gfn_rdsid78 child WHERE child.gid = 1276643), 'rds_autogenerated.rdsid78_pointseed_urbanflood_singlepoint', 'geom', 3, 10)
What would be the optimal of getting back my unioned geometries?