Thread

1. Re: [GENERAL] Geometric operators

   Jeff Hoffmann <jeff@remapcorp.com> — 1999-06-18T16:03:20Z

   Steffen Zimmert wrote:
   > 
   > Hello everybody,
   > 
   > I am wondering if the geometric datatypes of the PostgreSQL system allow
   > the following queries.
   > The database should contain the box datatype which is used as the index.
   > The system should allow queries like "Retrieve all boxes that are
   > contained in the query box". Is that possible with the standard types of
   > the system?
   
   It should be working (at least it worked fine in 6.4.2).  The operator
   you are looking for is "&&" which is a box overlap. For example, if you
   create a table with a box field (we'll call it "box_field"), you could
   create an index on it (if you have a lot of records):
   
   create index mytable_index on my_table using rtree (box_field box_ops);
   
   and then a select would be
   
   select * from mytable where box_field && '(100,100),(200,200)'::box;
   
   where the '(100,100),(200,200)'::box would be the bounding query box. 
   If you read my question from earlier today, you'll notice i'm having
   problems with it in 6.5.  I don't know if that's just me or something
   that's changed since 6.4.2.
   
   

2. Geometric operators

   Steffen Zimmert <szimmert@crcg.edu> — 1999-06-18T18:48:28Z

   Hello everybody,
   
   I am wondering if the geometric datatypes of the PostgreSQL system allow
   the following queries.
   The database should contain the box datatype which is used as the index.
   The system should allow queries like "Retrieve all boxes that are
   contained in the query box". Is that possible with the standard types of
   the system?
   
   -- 
   Best Regards,
   Steffen Zimmert
   
   
   Steffen Zimmert
   Fraunhofer Center for Research in Computer Graphics
   Providence, Rhode Island, USA
   email: szimmert@crcg.edu