Re: rtree_gist work

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: jankorichter(at)yahoo(dot)de, pgsql-hackers(at)postgresql(dot)org
Subject: Re: rtree_gist work
Date: 2005-07-02 16:51:29
Message-ID: 87fyuxw3qm.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Janko Richter 2005-07-02 17:57:58 Re: rtree_gist work
Previous Message Janko Richter 2005-07-02 14:47:13 Re: rtree_gist work