Re: [HACKERS] compress method for spgist - 2
От | Alexander Korotkov |
---|---|
Тема | Re: [HACKERS] compress method for spgist - 2 |
Дата | |
Msg-id | CAPpHfdsAoqxD+=cGyri3iSqHDTc7HrCRWRwgpU86mC+k8moJiA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [HACKERS] compress method for spgist - 2 (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Thu, Sep 21, 2017 at 3:14 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
OK. I'll try implement this for circles.
Alexander Korotkov <aekorotkov@gmail.com> writes:
> On Thu, Sep 21, 2017 at 2:06 AM, Darafei "Komяpa" Praliaskouski <
>> It seems to me that any circle with radius of any Infinity should become a
>> [-Infinity .. Infinity, -Infinity .. Infinity] box.Then you won't have
>> NaNs, and index structure shouldn't be broken.
> We probably should produce [-Infinity .. Infinity, -Infinity .. Infinity]
> box for any geometry containing inf or nan.
Hm, we can do better in at least some cases, eg for a box ((0,1),(1,inf))
there's no reason to give up our knowledge of finite bounds for the
other three boundaries. But certainly for a NaN circle radius
what you suggest seems the most sensible thing to do.
The Russian Postgres Company
В списке pgsql-hackers по дате отправления: