[postgis-users] General PostGIS & GEOS comments and questions

[David Blasby]

Vinko Vrsalovic wrote:
> I'll prepare a small set of data and sql and send it before Monday.

Excellent!


> Exactly, that was what i first tried to do, but the problem is that
> other_geom is a multityped column, it has polygons, points, lines and
> collections and when calling the exact same query, the server crashes.
 >
> I guess I'll have to redesign the model to separate the other_geom into
> basic types... will contains() work on generic column types if each
> row is not a collection? It seems to me that it would...

Yes - you might just have to explode your table into non-collections.

dave