Polygons passed to poly_overlap have 0 pts when column is indexed using rtree - Mailing list pgsql-hackers

From Kenneth Chan
Subject Polygons passed to poly_overlap have 0 pts when column is indexed using rtree
Date
Msg-id 20020528180658.20130.qmail@iname.com
Whole thread Raw
Responses Re: Polygons passed to poly_overlap have 0 pts when column is indexed using rtree  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
This “feature” does not affect the original version of poly_overlap as only a bounding box test is preformed.  I
modifiedpoly_overlap in an attempt to improve the preciseness of poly_overlap.  The function works when the column is
notindexed or when the column is indexed using  rtree_gist from the contrib section, but fails when the column is
indexedusing rtree.  Turned out that npts of the polygon retrieved from the table is 0 (the other polygon is a constant
andits 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



pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: strange update problem with 7.2.1
Next
From: Tom Lane
Date:
Subject: Re: strange update problem with 7.2.1