<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">perhaps:<DIV><BR class="khtml-block-placeholder"></DIV><DIV> select convexhull(collect(the_geom) from thetable<DIV><BR class="khtml-block-placeholder"></DIV><DIV>depends on what semantic you mean when you say "if convexhull was an aggregate".</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>P</DIV><DIV><BR><DIV><DIV>On 21-Sep-06, at 10:44 AM, Curtis W. Ruck wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV>Anyone know how in a SQL select statement to get a Convex Hull polygon geometry as if ConvexHull was an aggregate function?</DIV> <DIV> </DIV> <DIV>Curtis</DIV></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">postgis-users mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></DIV></BODY></HTML>