This project is read-only.

RelateQuery and Intersects got different results?

Topics: Developer Forum, Project Management Forum, User Forum
Mar 27, 2012 at 5:13 AM

HI,Everyone:

     I want to do insection search on my shp. I used RelateQuery

“SELECT ST_t.* FROM [ST].[RelateQuery]('AnGeoPolygon', 'the_geom', [ST].[PointFromText]('Point(5 5)',4326), 'Intersects') AS ST_q INNER JOIN [dbo].[AnGeoPoint] AS ST_t ON ST_q.[oid] = ST_t.[oid]” 

    and ST.Intersects

“SELECT * FROM AnGeoPoint where ST.[Intersects](the_geom,ST.PointFromText('Point(5 5)',4326)) = 1”。

But only ST.Intersects returned two right items,the ST.RelateQuery reurned nothing.  Is there any errors in ST.RelateQuery in my SQL?

Thanks