Aggregate functions for TopoGeometries

[Felipe Matas]

 Hi, I discovered that functions preparing the talk for the PostgisDay :
I still I think would be nicer to work directly with TopoGeometries than TopoElements in this cases, is also more intuitive, there is a lot of advantages to use them :)
Thx!
    El miércoles, 13 de noviembre de 2024, 04:51:08 a. m. GMT-3, Sandro Santilli <strk at kbt.io> escribió:  
 
 On Tue, Nov 12, 2024 at 08:38:46PM +0000, Felipe Matas wrote:
> Hi latot here, to construct new TopoGeometries using other
> TopoGeometries we need to convert to TopoElements, make an array with
> them, I think would be ver nice have functions to instead work with
> TopoElements work directly with TopoGeometries.

You can use the cast from TopoGeometry to TopoElement and the
TopoElementArray_agg aggregate to obtain that:


  SELECT TopoElementArray_agg(tg::TopoElement) FROM myLayer;

See https://postgis.net/docs/TopoElement.html
and https://postgis.net/docs/TopoElementArray_Agg.html

--strk;

  Libre GIS consultant/developer
  https://strk.kbt.io/services.html
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20241113/2c746b71/attachment-0001.htm>