Polygons passed to poly_overlap have 0 pts when column is indexed using rtree

Поиск
Список
Период
Сортировка
От Kenneth Chan
Тема Polygons passed to poly_overlap have 0 pts when column is indexed using rtree
Дата
Msg-id 20020528180658.20130.qmail@iname.com
обсуждение исходный текст
Ответы Re: Polygons passed to poly_overlap have 0 pts when column is indexed using rtree  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: strange update problem with 7.2.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: strange update problem with 7.2.1