<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">I was so pleased to find this dissolve function from <A href="mailto:strk@keybit.net"><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">strk@keybit.net</SPAN></FONT></A> among the old posts. Is there any way that it could be added to the online documentation?<DIV><BR class="khtml-block-placeholder"></DIV><DIV>In fact, it would be really great if there could be a section in the documentation for custom functions such as this. These are the sort of tools that really ramp up the usefulness of postgis.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Thanks,</DIV><DIV>nelson</DIV><DIV><BR class="khtml-block-placeholder"><DIV><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">CREATE AGGREGATE unite (</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> </SPAN></FONT><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">sfunc = GeomUnion,</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> </SPAN></FONT><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">basetype = geometry,</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> </SPAN></FONT><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">stype = geometry</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">); -- this creates an aggregate out of GEOS's geomunion()</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 13.3px/normal Courier; min-height: 16px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">-- and this is your query</SPAN></FONT><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> </SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">SELECT your_attribute, unite(the_geom)</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">FROM your_table</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">GROUP BY your_attribute;</SPAN></FONT></DIV></DIV></BODY></HTML>