QUERY: CREATE TABLE BOX_TBL (f1 box); QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(2.0,2.0,0.0,0.0)'); QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(1.0,1.0,3.0,3.0)'); QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(2.5, 2.5, 2.5,3.5)'); QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(3.0, 3.0,3.0,3.0)'); QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(2.3, 4.5)'); WARN:Bad box external representation '(2.3, 4.5)' QUERY: INSERT INTO BOX_TBL (f1) VALUES ('asdfasdf(ad'); WARN:Bad box external representation 'asdfasdf(ad' QUERY: SELECT '' AS four, BOX_TBL.*; four|f1 ----+----------------- |(2,2,0,0) |(3,3,1,1) |(2.5,3.5,2.5,2.5) |(3,3,3,3) (4 rows) QUERY: SELECT '' AS four, b.*, box_area(b.f1) as barea FROM BOX_TBL b; four|f1 |barea ----+-----------------+----- |(2,2,0,0) | 4 |(3,3,1,1) | 4 |(2.5,3.5,2.5,2.5)| 0 |(3,3,3,3) | 0 (4 rows) QUERY: SELECT '' AS three, b.f1 FROM BOX_TBL b WHERE b.f1 && '(2.5,2.5,1.0,1.0)'::box; three|f1 -----+----------------- |(2,2,0,0) |(3,3,1,1) |(2.5,3.5,2.5,2.5) (3 rows) QUERY: SELECT '' AS two, b1.* FROM BOX_TBL b1 WHERE b1.f1 &< '(2.0,2.0,2.5,2.5)'::box; two|f1 ---+----------------- |(2,2,0,0) |(2.5,3.5,2.5,2.5) (2 rows) QUERY: SELECT '' AS two, b1.* FROM BOX_TBL b1 WHERE b1.f1 &> '(2.0,2.0,2.5,2.5)'::box; two|f1 ---+----------------- |(2.5,3.5,2.5,2.5) |(3,3,3,3) (2 rows) QUERY: SELECT '' AS two, b.f1 FROM BOX_TBL b WHERE b.f1 << '(3.0,3.0,5.0,5.0)'::box; two|f1 ---+----------------- |(2,2,0,0) |(2.5,3.5,2.5,2.5) (2 rows) QUERY: SELECT '' AS four, b.f1 FROM BOX_TBL b WHERE b.f1 <= '(3.0,3.0,5.0,5.0)'::box; four|f1 ----+----------------- |(2,2,0,0) |(3,3,1,1) |(2.5,3.5,2.5,2.5) |(3,3,3,3) (4 rows) QUERY: SELECT '' AS two, b.f1 FROM BOX_TBL b WHERE b.f1 < '(3.0,3.0,5.0,5.0)'::box; two|f1 ---+----------------- |(2.5,3.5,2.5,2.5) |(3,3,3,3) (2 rows) QUERY: SELECT '' AS two, b.f1 FROM BOX_TBL b WHERE b.f1 = '(3.0,3.0,5.0,5.0)'::box; two|f1 ---+--------- |(2,2,0,0) |(3,3,1,1) (2 rows) QUERY: SELECT '' AS two, b.f1 FROM BOX_TBL b WHERE b.f1 > '(3.5,3.0,4.5,3.0)'::box; two|f1 ---+--------- |(2,2,0,0) |(3,3,1,1) (2 rows) QUERY: SELECT '' AS four, b.f1 FROM BOX_TBL b WHERE b.f1 >= '(3.5,3.0,4.5,3.0)'::box; four|f1 ----+----------------- |(2,2,0,0) |(3,3,1,1) |(2.5,3.5,2.5,2.5) |(3,3,3,3) (4 rows) QUERY: SELECT '' AS two, b.f1 FROM BOX_TBL b WHERE '(3.0,3.0,5.0,5.0)'::box >> b.f1; two|f1 ---+----------------- |(2,2,0,0) |(2.5,3.5,2.5,2.5) (2 rows) QUERY: SELECT '' AS three, b.f1 FROM BOX_TBL b WHERE b.f1 @ '(0,0,3,3)'::box; three|f1 -----+--------- |(2,2,0,0) |(3,3,1,1) |(3,3,3,3) (3 rows) QUERY: SELECT '' AS three, b.f1 FROM BOX_TBL b WHERE '(0,0,3,3)'::box ~ b.f1; three|f1 -----+--------- |(2,2,0,0) |(3,3,1,1) |(3,3,3,3) (3 rows) QUERY: SELECT '' AS one, b.f1 FROM BOX_TBL b WHERE '(1,1,3,3)'::box ~= b.f1; one|f1 ---+--------- |(3,3,1,1) (1 row) QUERY: SELECT '' AS four, @@(b1.f1) AS p FROM BOX_TBL b1; four|p ----+------- |(1,1) |(2,2) |(2.5,3) |(3,3) (4 rows) QUERY: SELECT '' AS one, b1.*, b2.* FROM BOX_TBL b1, BOX_TBL b2 WHERE b1.f1 ~ b2.f1 and not b1.f1 ~= b2.f1; one|f1 |f1 ---+---------+--------- |(3,3,1,1)|(3,3,3,3) (1 row)