[postgis-users] Collect vs. ST_Collect GeomUnion vs ST_GeomUnion

Obe, Regina robe.dnd at cityofboston.gov
Tue Aug 21 14:40:35 PDT 2007


I just installed the new version of 1.3.1 and noticed something which
I'm not sure was intended or not or if something went amiss with my
upgrade.
 
Before there used to be 2 formats of collect
 
That which takes two geometries used like so - which I see has an alias
st_collect
 
st_collect(geom1, geom2)
 
and there was another variant of collect which is used as an aggregate
function
 
SELECT collect(geom)
FROM sometable
GROUP BY somefield
 
In my version the old collect aggregate function does not seem to have
been aliased as well to st_collect.
 
E.g. doing
 
SELECT st_collect(geom)
FROM sometable
GROUP BY somefield 
 
gives me  an error while the old 
 
SELECT collect(geom)
FROM sometable
GROUP BY somefield 
 
still works.
 
I have the same issue with geomunion vs. st_geomunion
 
Am I missing something?
 
Thanks,
Regina



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070821/4948b185/attachment.html>


More information about the postgis-users mailing list