[postgis-users] Problem with using ST_Intersects within a Function

[rox]

 On Thu, 01 Sep 2011 14:38:54 -0400, rox <rox at tara-lu.com> 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