[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Polygon union
From:       Brian Sanjeewa Rupasinghe <jinkabs () gmail ! com>
Date:       2013-11-29 21:31:21
Message-ID: CAEMA-4j2_eEhYZRZonQmP-CuNEMWY8EsNMT9_PC7Cereb_+c6A () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi,

I use ST_union aggregate function to union a set of polygons with group by
clause.
I see there is another function ST_UnaryUnion() in PostGIS. Can i use it
instead of
normal ST_Union? When i replaced ST_Union with ST_UnaryUnion in the query,
it gave me an error because it is not an aggregate function. So how to use
this function
in a PostGIS query which selects group of polygons using group by clause?

Cheers, Brian.

[Attachment #5 (text/html)]

<div dir="ltr">Hi,<div><br></div><div>I use ST_union aggregate function to union a \
set of polygons with group by clause.</div><div>I see there is another function \
ST_UnaryUnion() in PostGIS. Can i use it instead of</div><div> normal ST_Union? When \
i replaced ST_Union with ST_UnaryUnion in the query,</div><div>it gave me an error \
because it is not an aggregate function. So how to use this function</div><div>in a \
PostGIS query which selects group of polygons using group by clause?</div> \
<div><br></div><div>Cheers, Brian.</div></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]