Stefan de Konink-3 wrote: > > > It is really a bitch that PostgreSQL cannot use the ST_IsValid as index > in queries. Yes, you could manually do the boolean operation yourself, > but still it would be quite handy if the validness wouldn't be checked > at all if it was valid in the first place. > > >
Why not? I think an index like [1] should work and speed up your queries as the validity is only checked once on insert or on the build operation. regards, Melchior [1] CREATE INDEX idx_planet_osm_polygon_valid ON planet_osm_polygon USING btree (ST_IsValid(way)); -- View this message in context: http://gis.638310.n2.nabble.com/invalid-geometry-in-planet-polygon-tp5454655p5457332.html Sent from the Developer Discussion mailing list archive at Nabble.com. _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
