Re: rtree_gist work - Mailing list pgsql-hackers

From Greg Stark
Subject Re: rtree_gist work
Date
Msg-id 87fyuxw3qm.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: rtree_gist work  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: rtree_gist work  ("Janko Richter" <jankorichter@yahoo.de>)
List 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 by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: 2PC transaction id
Next
From: "Janko Richter"
Date:
Subject: Re: rtree_gist work