On Thu, 01 Sep 2011 14:38:54 -0400, rox <[email protected]> wrote:
I am fairly new to Postgres (1995-96, and now again) and totally new
to GIS.
We're working with an inherited database in which we know there are
invalid geometries.
Rather than continue to let various queries fail, I'm working on a
way to detect the specific entries so we can go clean them up.
I've been working on a function that will test a geometry for
validity within the following functions:
I have the following test scenario to demonstrate my current
challenge:
I hate tab sometimes.
The rest of the test scenario:
-- Executing the following results in "valid" [true] results
select id, st_intersects(loc,loc)
from testloc ;
-- Executing the following results in a parse error
select id, testgeom(id,loc)
from testloc ;
Roxanne
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
