<div dir="ltr">
<div>Dear Chris,</div><div>Thank you. Indeed, You right.</div><div>But when i rerun the query with the edit (adding the closing parenthesis) : </div><div><br><i><span style="background-color:rgb(204,204,204)"><span class="gmail-im">SELECT <br> min(union_v4.max_hierar) as id, <br> array_agg(<a href="http://union_v4.id" target="_blank">union_v4.id</a>) as ids, <br> union_v6.geom<br>FROM union_v4,<br> (SELECT <br> (ST_Dump(St_multi(ST_Union(geom)))).geom as geom<br> FROM union_v6)<br>WHERE <br> st_intersects(union_v4.geom, union_v6.geom)<br>GROUP BY union_v6.geom</span></span></i></div><div><br></div><div>I obtain this time the message : <i><br><span style="background-color:rgb(204,204,204)"><br></span></i>
<span style="color:rgb(34,34,34);font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:0.14994px;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px;white-space:pre-wrap;text-decoration-style:initial;text-decoration-color:initial;display:inline;float:none;background-color:rgb(204,204,204)">ERROR: la relation « union_v4 » n'existe pas
LINE 5: FROM union_v4,
^
ERREUR: la relation « union_v4 » n'existe pas
SQL state: 42P01
Character: 105</span><span style="background-color:rgb(204,204,204)"><br><br><br></span></div><div><span style="background-color:rgb(255,255,255)">However, i have one table called "union_v4" within my postgis db. <br></span></div><div><span style="background-color:rgb(255,255,255)">thanks so much.</span></div>
<br></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">Le mar. 30 sept. 2025 à 17:39, chris hermansen <<a href="mailto:clhermansen@gmail.com">clhermansen@gmail.com</a>> a écrit :<br></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="auto"><div dir="auto">Laurent and list,</div><br><br><div class="gmail_quote" dir="auto"><div dir="ltr" class="gmail_attr">On Tue, Sep 30, 2025, 07:14 celati Laurent via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>> wrote:<br></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"><div dir="ltr">
Dear all,<div><br>I work with qgis and postgis. I would like to perform a "dissolve": </div><div><a href="https://docs.qgis.org/3.40/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#dissolve" rel="noreferrer" target="_blank">https://docs.qgis.org/3.40/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#dissolve</a><br><br>in keeping/preserving all attributes values ? For instance : a kind of aggregation/concatenation within new "output features" ?</div><div><br></div><div>I Saw this post :</div><div><a href="https://www.aproposinfosystems.com/en/about/blog/managing-attributes-postgis-dissolve/" rel="noreferrer" target="_blank"> https://www.aproposinfosystems.com/en/about/blog/managing-attributes-postgis-dissolve/</a><br><br>I have tried to reproduce the proposal with my postgis table containing several polygons<br><span style="background-color:rgb(204,204,204)"><br><i>SELECT <br>min(union_v4.max_hierar) as id, <br>array_agg(<a href="http://union_v4.id" rel="noreferrer" target="_blank">union_v4.id</a>) as ids, <br>union_v6.geom<br>FROM <br>union_v4, <br>(SELECT <br>(ST_Dump(St_multi(ST_Union(geom)))).geom as geom <br>FROM union_v6<br>WHERE <br>st_intersects(union_v4.geom, union_v6.geom)<br>GROUP BY union_v6.geom</i></span><br><br>But i obtain :<br><br><i><span style="background-color:rgb(204,204,204)">ERROR: syntax error at the end of the entry<br>LINE 12: GROUP BY union_v6.geom <br>^<br>ERROR: syntax error at the end of the entry<br>SQL state: 42601<br>Characters: 285</span></i></div><div></div></div></div></blockquote></div><div dir="auto"><br></div><div dir="auto">I'm on my phone and squinting a bit here but aren't you missing a right parenthesis? Ending your correlated sub query?</div><div class="gmail_quote" dir="auto"><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"><div dir="ltr"><div><br></div></div></div>
</blockquote></div></div>
</blockquote></div>