This ï¿½featureï¿½ does not affect the original version of poly_overlap as only a bounding box test is preformed.  I modified poly_overlap in an attempt to improve the preciseness of poly_overlap.  The function works when the column is not indexed or when the column is indexed using  rtree_gist from the contrib section, but fails when the column is indexed using rtree.  Turned out that npts of the polygon retrieved from the table is 0 (the other polygon is a constant and its attributes are correct).  I suspect the ï¿½featureï¿½ might affect other functions that uses polygons->npts like poly_contain.  Would anyone happens to know the identity of the ï¿½offendingï¿½ function might be?

TIA 

Kenneth Chan
-- 
_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup


Tue, 28 May 2002 13:06:58 -0500
"Kenneth Chan" <kkchan@technologist.com>
Polygons passed to poly_overlap have 0 pts when column is indexed
	using rtree
"Kenneth Chan" <kkchan@technologist.com> writes:
> ... Turned out that npts of the
> polygon retrieved from the table is 0 (the other polygon is a constant
> and its attributes are correct).  I suspect the �feature� might
> affect other functions that uses polygons->npts like poly_contain.
> Would anyone happens to know the identity of the �offending�
> function might be?  TIA

No, but if you can post an example demonstrating the problem, I'm sure
we can find it...

			regards, tom lane

Tue, 28 May 2002 15:06:34 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Polygons passed to poly_overlap have 0 pts when column is indexed
	using rtree