Hmmm, the very simple example didn't expose the issue probably because it has only two rows of data and the index is not being used.  

For poly_contain, I guess one alternative is to use the result of the box_contain test and not proceed to the point_inside test if one of the poly->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.

			regards, tom lane


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


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