open lwpostgis.sql and look for ST_Union. I see the aggregate def'n in
my source. Don't you?
P
On 28-May-09, at 12:59 PM, Dylan Beaudette wrote:
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
<[email protected]> 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
[email protected]
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
