Re: Patch: add GiST support for BOX @> POINT queries

Поиск
Список
Период
Сортировка
От Hitoshi Harada
Тема Re: Patch: add GiST support for BOX @> POINT queries
Дата
Msg-id CAP7Qgmkb91Dex3Gm6imngvtTYiSWgXJp01a+DaYs1u3w8UQ0CA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Patch: add GiST support for BOX @> POINT queries  (Hitoshi Harada <umi.tanuki@gmail.com>)
Список pgsql-hackers
2011/6/19 Hitoshi Harada <umi.tanuki@gmail.com>:
> 2011/6/17 Andrew Tipton <andrew.t.tipton@gmail.com>:
>>
>> At this point I'm a bit lost -- while pg_amop.h has plenty of examples
>> of crosstype comparison operators for btree index methods, there are
>> none for GiST.  Is GiST somehow a special case in this regard?
>
> It was I that was lost. As Tom mentioned, GiST indexes have records in
> pg_amop in their specialized way. I found gist_point_consistent has
> some kind of hack for that and pg_amop for point_ops records have
> multiple crosstype for that. So, if I understand correctly your first
> approach modifying gist_box_consistent was the right way, although
> trivial issues should be fixed. Also, you may want to follow point_ops
> when you are worried if the counterpart operator of commutator should
> be registered or not.
>
> Looking around those mechanisms, it occurred to me that you mentioned
> only box @> point. Why don't you add circly @> point, poly @> point as
> well as box? Is that hard?
>

It looks like the time to wrap up. I marked "Return with Feedback" on
this patch, since response from author has not come for a while. You
may think the fix was pretty easy and the patch be small, but more
general approach was preferred, I guess. Looking forward to seeing it
in better shape next time!

Thanks,
--
Hitoshi Harada


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hitoshi Harada
Дата:
Сообщение: Re: Parameterized aggregate subquery (was: Pull up aggregate subquery)
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: [GENERAL] Creating temp tables inside read only transactions