[postgis-users] points to polygon

[Arnaud Lesauvage]

Le 2/03/2010 10:35, Nicola Zandonà a écrit :
> I have a set of point extracted from longitude and latitude coordinates.
> I'd like to circumscribe those points inside a polygon.
> Can I solve this problem with an aggregate function?

Yes, I think you are looking for ST_ConvexHull :
http://postgis.refractions.net/documentation/manual-1.5/ST_ConvexHull.html

This is not an aggregate function so you have to aggregate your point 
geometries before calling it. You can use ST_Collect for that.

Regards
--
Arnaud