Hmmm, the really simple example didn't work probably becaure there are not enough rows in the test tables for the system to use the index instead of doing a sequential scan.

For poly_contained and other functions that use npts, maybe the code can take into account that npts maybe 0 by doing the bounding box test and proceed to more accurate tests only if npts > 0.  

Ken.


----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Tue, 28 May 2002 23:29:08 -0400
To: "Kenneth Chan" <kkchan@technologist.com>
Subject: Re: [HACKERS] Polygons passed to poly_overlap have 0 pts when 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

It appears that the issue is not rtree itself, but the rt_poly_union
and rt_poly_inter functions, which produce "polygons" that have only
bounding boxes.  Not sure whether that should be considered erroneous
or not.  The dummy polygons are evidently used as internal node keys
in the rtree.


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


Wed, 29 May 2002 20:40:15 -0500
"Kenneth Chan" <kkchan@technologist.com>
Re: Polygons passed to poly_overlap have 0 pts when