[postgis-users] st_collect, st_union

[Bob Pawley]

Hi

The table is attached.

Following is the query I used.

select st_collect(import_process.wkb_geometry)
from import_process;

Bob

-----Original Message----- 
From: Sandro Santilli
Sent: Wednesday, June 29, 2011 10:11 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] st_collect, st_union

On Wed, Jun 29, 2011 at 09:54:49AM -0700, Bob Pawley wrote:
> Hi
>
> I have a table with five rows each holding a linestring geometry.
>
> Each of theses geometries indicate true on an st_isvalid query.
>
> All rows are displayed as expected in QGis.
>
> However, when I run an st_union or st_collect query on all five rows the 
> return is empty.
>
> If I select only four of the five rows (any four)  it returns a value.
>
> Can anyone suggest what type of problem I should look for? Is there some 
> restriction on these functions?

That's a really odd behavior. Can you provide a dump of your table ?

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: E5R.backup
Type: application/octet-stream
Size: 8701 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110629/68c53cef/attachment.obj>