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

[Mark Cave-Ayland]

On Tue, 2007-08-21 at 17:40 -0400, Obe, Regina wrote:
> 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


Hi Regina,

I can see the st_collect() in the lwpostgis.sql.in file, so it should be
defined for a new installation. Have you got more information on how you
performed your upgrade?


Kind regards,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk