[postgis-users] ST_GeomUnion, ST_Union

[Mark Cave-Ayland]

On Wed, 2007-08-22 at 08:19 -0400, Obe, Regina wrote:
> I notice that in the 1.3.1 that the aggregate function is called
> ST_Union instead of ST_GeomUnion  and that the regular function is
> called
>  
> ST_GeomUnion(geom, geom) 
>  
> Since the old aggregate was call GeomUnion I had assumed the new would
> just have an ST_ prepended to it.
>  
> I assume this is intended because of some OGC requirement.  I'm just
> wondering why they aren't named consistently the same like 
> ST_collect aggregate and regular functions.
>  
> Thanks,
> Regina


Hi Regina,

The reason GeomUnion() exists instead of being just Union() is that
UNION is a PostgreSQL reserved word and so can't be used as a function
name :(


ATB,

Mark.

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