[postgis-users] ConvexHull Aggregate?

[Curtis W. Ruck]

Yay, it works... now time to make it output in sq kilometers with an area() and a transform()


----- Original Message ----
From: Michael Fuhr <mike at fuhr.org>
To: Curtis W. Ruck <ruckc at yahoo.com>; PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Thursday, September 21, 2006 9:04:25 PM
Subject: Re: [postgis-users] ConvexHull Aggregate?


On Thu, Sep 21, 2006 at 06:26:37PM -0700, Curtis W. Ruck wrote:
> SELECT convexhull(collect(the_geom)), category, count(*) FROM tblName GROUP BY category;
> 
> convexhull isn't an aggregate function so it can't work in this context.  

Works here, just as AsText(collect(the_geom)) would.  What happened
when you tried it?

-- 
Michael Fuhr
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060922/8d6d6258/attachment.html>