[postgis-users] st_collect, st_union

[Sandro Santilli]

On Thu, Jun 30, 2011 at 08:55:04AM -0700, Bob Pawley wrote:
> I see what you mean.
> 
> Try this one. It does import and will st_collect with fewer than the
> five rows but returns an empty value for all rows.

$ pg_restore import_process.backup  | psql
$ psql
strk=# select st_summary(st_collect(wkb_geometry)) from import_process;
             st_summary
-------------------------------------
 MultiLineString[ZB] with 5 elements
   LineString[M] with 46 points
   LineString[M] with 2 points
   LineString[M] with 46 points
   LineString[M] with 46 points
   LineString[M] with 46 points

(1 row)

strk=# select postgis_full_version();
                                           postgis_full_version                 
----------------------------------------------------------------------------------------------------------
 POSTGIS="2.0.0SVN" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.6" USE_STATS
(1 row)

You are facing bad dragons.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html