[postgis-users] collect and geomunion return null when linestring is not continuo us...

[John Cole]

I am trying to create a single linestring (at reduced resolution) but have
run into a problem.  I noticed that the results of some of my roads had null
values.

I had been using a 'select collect(the_geom) from roads group by roadname'
with some success until this.  Examining the offending roads, it turns out
that the road in question has gaps in it (because of a selection criteria).

I expected that collect (or geomunion, which behaves just like collect) to
return a geometry collection of each road segment instead of null.

Am I wrong in that expectation?

Thanks,

John

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/698 - Release Date: 2/23/2007
4:39 AM
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.