On Tue, Sep 11, 2012 at 3:44 AM, René Fournier <m...@renefournier.com> wrote:
> Thanks Nicolas,
>
> UPDATE territories SET border =
> ST_ConvexHull(ST_Collect(ST_GeomFromText('MULTIPOINT(50.569455 -111.868842,
> 50.569992 -111.898634, 50.583764 -111.907919, 50.569452 -111.868859)') ) )
> WHERE id = 3014;
> ERROR: cannot use aggregate function in UPDATE
> LINE 1: UPDATE territories SET border = ST_ConvexHull(ST_Collect(ST_...
>
Using a sub-select should work:
UPDATE territories SET border = (SELECT
ST_ConvexHull(ST_Collect(ST_GeomFromText('MULTIPOINT(50.569455
-111.868842, 50.569992 -111.898634, 50.583764 -111.907919, 50.569452
-111.868859)') ) ))
WHERE id = 3014;
regards
p
--
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
