[postgis-devel] Proposal: ST_Overlay function

[Дорофей Пролесковский]

>
> Is it possible to have a set-returning aggregate function in Postgres?
> Are you thinking the set would just have a schema just containing a
> geometry field?
>

Unfortunately it seems like not. However it will be a perfect thing
semantically. Maybe someone knows if this limitation is easy to lift?

21:10:42 [kom] > create aggregate st_dissolve(geometry) (stype=geometry,
sfunc=ST_Union,initcond='POLYGON EMPTY',finalfunc=ST_Dump);
ERROR:  42804: function st_dump(geometry) returns a set
LOCATION:  lookup_agg_function, pg_aggregate.c:874
Time: 0,172 ms
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20210726/95efa1fc/attachment-0001.html>