[postgis-users] error in geometry operations

[P Kishor]

-- Executing query:
SELECT  a.id, b.id
FROM    a, b
WHERE   a.the_geom && b.the_geom AND WITHIN(b.the_geom, a.the_geom)
LIMIT 10

oh crap! row number -1 is out of range 0..-1
Total query runtime: 360258 ms.


any ideas, anyone?

additionally, for a query like above, what all indexes are advised? I
have the_geom in both tables indexed using GiST, fwiw.

-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/