<div dir="ltr"><div dir="ltr"><br></div><div class="gmail_quote"><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" style="overflow-wrap: break-word;"><div class="gmail_quote" style="overflow-wrap: break-word;"><div style="overflow-wrap: break-word;"><br class="gmail-Apple-interchange-newline">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? </div></div></div></blockquote><div style="overflow-wrap: break-word;"><br style="overflow-wrap: break-word;"></div><div style="overflow-wrap: break-word;">Unfortunately it seems like not. However it will be a perfect thing semantically. Maybe someone knows if this limitation is easy to lift?</div><div style="overflow-wrap: break-word;"><span style="font-family:monospace"><span style="color:rgb(178,104,24)"><br style="overflow-wrap: break-word;"></span></span></div><div style="overflow-wrap: break-word;"><span style="font-family:monospace"><span style="color:rgb(178,104,24)">21:10:42</span><span style="color:rgb(0,0,0)"> [</span><span style="font-weight:bold;color:rgb(255,84,84)">kom</span><span style="color:rgb(0,0,0)">] > create aggregate st_dissolve(geometry) (stype=geometry, sfunc=ST_Union,initcond='POLYGON EMPTY',finalfunc=ST_Dump);  </span><br style="overflow-wrap: break-word;">ERROR:  42804: function st_dump(geometry) returns a set<br style="overflow-wrap: break-word;">LOCATION:  lookup_agg_function, pg_aggregate.c:874<br style="overflow-wrap: break-word;">Time: 0,172 ms</span></div></div></div></div>