[postgis-users] ST_Union does not exist

[Dylan Beaudette]

On Thursday 28 May 2009, Paul Ramsey wrote:
> Operator error? It exists in 1.3.6 as an aggregate, as before. Could
> something in your upgrade procedure have dropped it?
>
> P

Yeah... I was thinking about that. Why is it that I do not see a CREATE 
AGGREGATE ST_Union(geometry) or anything like that in the source code?

Cheers,

Dylan


> On Thu, May 28, 2009 at 12:13 PM, Dylan Beaudette
>
> <debeaudette at ucdavis.edu> wrote:
> > Hi,
> >
> > Noticed this today:
> >
> > -- basic query
> > SELECT ST_Buffer(ST_UNION(wkb_geometry), 0.1) as wkb_geometry
> > FROM
> >        (
> >        SELECT 1 as id, wkb_geometry
> >        FROM map
> >        ) as a
> > GROUP BY a.id;
> >
> > -- error message
> > ERROR:  function st_union(geometry) does not exist
> >
> > -- software version (Postgresql 8.3.7)
> > POSTGIS="1.3.6" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007"
> > USE_STATS
> >
> > Could this be related to my recent upgrade from postgis 1.3.3 ? Other
> > postgis queries seem to work.
> >
> > I was able to get a result using GeomUnion(geometry)--- but for anything
> > more than a couple features this would take > 1 hour, not finishing, and
> > could not be canceled by the user.
> >
> > Grepping through the source reveals:
> > /src/postgresql-8.3.7/contrib/postgis-1.3.6$ grep -R -i
> > 'st_union(geometry)' *
> >
> > postgis_comments.sql:COMMENT ON AGGREGATE ST_Union(geometry) IS 'args:
> > g1field - Returns a geometry that represents the point set union of the
> > Geometries.';
> >
> > Ideas?
> >
> > Dylan
> >
> >
> > --
> > Dylan Beaudette
> > Soil Resource Laboratory
> > http://casoilresource.lawr.ucdavis.edu/
> > University of California at Davis
> > 530.754.7341
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users



-- 
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341