Re: rtree_gist work

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: rtree_gist work
Дата
Msg-id 87fyuxw3qm.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: rtree_gist work  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: rtree_gist work  ("Janko Richter" <jankorichter@yahoo.de>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> As an example, contains/contained in are pretty meaningless for two points;
> but it would be very useful to directly support queries like "point is
> contained in box?", "point is contained in circle?" on a point column.

Just as a bit of supporting anecdotal evidence. I ended up storing longitude
and latitude redundantly in my tables as a point and also as a 0-area box just
so I could use the box <contains> box operator because there's no <box>
contains <point> operator.

-- 
greg



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

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: 2PC transaction id
Следующее
От: "Janko Richter"
Дата:
Сообщение: Re: rtree_gist work