<html><head></head><body><div class="ydp7994ae9dyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div dir="ltr" data-setdir="false">Hi, I discovered that functions preparing the talk for the PostgisDay :</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">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 :)</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Thx!<br></div>
</div><div id="yahoo_quoted_1508136675" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
El miércoles, 13 de noviembre de 2024, 04:51:08 a. m. GMT-3, Sandro Santilli <strk@kbt.io> escribió:
</div>
<div><br></div>
<div><br></div>
<div>On Tue, Nov 12, 2024 at 08:38:46PM +0000, Felipe Matas wrote:<br clear="none">> Hi latot here, to construct new TopoGeometries using other<br clear="none">> TopoGeometries we need to convert to TopoElements, make an array with<br clear="none">> them, I think would be ver nice have functions to instead work with<br clear="none">> TopoElements work directly with TopoGeometries.<br clear="none"><br clear="none">You can use the cast from TopoGeometry to TopoElement and the<br clear="none">TopoElementArray_agg aggregate to obtain that:<br clear="none"><br clear="none"><br clear="none"> SELECT TopoElementArray_agg(tg::TopoElement) FROM myLayer;<br clear="none"><br clear="none">See <a shape="rect" href="https://postgis.net/docs/TopoElement.html" target="_blank">https://postgis.net/docs/TopoElement.html</a><div class="yqt3498149112" id="yqtfd03673"><br clear="none">and </div><a shape="rect" href="https://postgis.net/docs/TopoElementArray_Agg.html" target="_blank">https://postgis.net/docs/TopoElementArray_Agg.html</a><br clear="none"><br clear="none">--strk;<br clear="none"><br clear="none"> Libre GIS consultant/developer<br clear="none"> <a shape="rect" href="https://strk.kbt.io/services.html" target="_blank">https://strk.kbt.io/services.html</a><div class="yqt3498149112" id="yqtfd19130"><br clear="none"></div></div>
</div>
</div></body></html>