QUERY: CREATE TABLE POINT_TBL(f1 point); QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)'); QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)'); QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)'); QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(5.1, 34.5)'); QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)'); QUERY: INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf'); WARN:Bad point external representation 'asdfasdf' QUERY: INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0'); QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)'); WARN:Bad point external representation '(10.0 10.0)' QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0'); WARN:Bad point external representation '(10.0,10.0' QUERY: SELECT '' AS six, POINT_TBL.*; six|f1 ---+---------- |(0,0) |(-10,0) |(-3,4) |(5.1,34.5) |(-5,-12) |(10,10) (6 rows) QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 << '(0.0, 0.0)'; three|f1 -----+-------- |(-10,0) |(-3,4) |(-5,-12) (3 rows) QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >> p.f1; three|f1 -----+-------- |(-10,0) |(-3,4) |(-5,-12) (3 rows) QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >^ p.f1; one|f1 ---+-------- |(-5,-12) (1 row) QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 <^ '(0.0, 0.0)'; one|f1 ---+-------- |(-5,-12) (1 row) QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 ~= '(5.1, 34.5)'; one|f1 ---+---------- |(5.1,34.5) (1 row) QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 @ '(0,0,100,100)'::box; three|f1 -----+---------- |(0,0) |(5.1,34.5) |(10,10) (3 rows) QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE not p.f1 @ '(0,0,100,100)'::box; three|f1 -----+-------- |(-10,0) |(-3,4) |(-5,-12) (3 rows) QUERY: SELECT '' AS two, p.* FROM POINT_TBL p WHERE p.f1 @ '[(0,0),(-10,0),(-10,10)]'::path; two|f1 ---+------- |(0,0) |(-10,0) (2 rows) QUERY: SELECT '' AS six, p.f1, p.f1 <-> '(0,0)'::point AS dist FROM POINT_TBL p ORDER BY dist; six|f1 | dist ---+----------+---------------- |(0,0) | 0 |(-3,4) | 5 |(-10,0) | 10 |(-5,-12) | 13 |(10,10) | 14.142135623731 |(5.1,34.5)|34.8749193547455 (6 rows) QUERY: SET geqo TO 'off'; QUERY: SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist FROM POINT_TBL p1, POINT_TBL p2 ORDER BY dist; thirtysix|point1 |point2 | dist ---------+----------+----------+---------------- |(10,10) |(10,10) | 0 |(-5,-12) |(-5,-12) | 0 |(5.1,34.5)|(5.1,34.5)| 0 |(-3,4) |(-3,4) | 0 |(-10,0) |(-10,0) | 0 |(0,0) |(0,0) | 0 |(0,0) |(-3,4) | 5 |(-3,4) |(0,0) | 5 |(-10,0) |(-3,4) |8.06225774829855 |(-3,4) |(-10,0) |8.06225774829855 |(-10,0) |(0,0) | 10 |(0,0) |(-10,0) | 10 |(-5,-12) |(0,0) | 13 |(-10,0) |(-5,-12) | 13 |(0,0) |(-5,-12) | 13 |(-5,-12) |(-10,0) | 13 |(10,10) |(0,0) | 14.142135623731 |(0,0) |(10,10) | 14.142135623731 |(10,10) |(-3,4) |14.3178210632764 |(-3,4) |(10,10) |14.3178210632764 |(-3,4) |(-5,-12) |16.1245154965971 |(-5,-12) |(-3,4) |16.1245154965971 |(-10,0) |(10,10) |22.3606797749979 |(10,10) |(-10,0) |22.3606797749979 |(5.1,34.5)|(10,10) |24.9851956166046 |(10,10) |(5.1,34.5)|24.9851956166046 |(-5,-12) |(10,10) |26.6270539113887 |(10,10) |(-5,-12) |26.6270539113887 |(-3,4) |(5.1,34.5)|31.5572495632937 |(5.1,34.5)|(-3,4) |31.5572495632937 |(5.1,34.5)|(0,0) |34.8749193547455 |(0,0) |(5.1,34.5)|34.8749193547455 |(-10,0) |(5.1,34.5)|37.6597928831267 |(5.1,34.5)|(-10,0) |37.6597928831267 |(-5,-12) |(5.1,34.5)|47.5842410888311 |(5.1,34.5)|(-5,-12) |47.5842410888311 (36 rows) QUERY: SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2 FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) > 3; thirty|point1 |point2 ------+----------+---------- |(-10,0) |(0,0) |(-3,4) |(0,0) |(5.1,34.5)|(0,0) |(-5,-12) |(0,0) |(10,10) |(0,0) |(0,0) |(-10,0) |(-3,4) |(-10,0) |(5.1,34.5)|(-10,0) |(-5,-12) |(-10,0) |(10,10) |(-10,0) |(0,0) |(-3,4) |(-10,0) |(-3,4) |(5.1,34.5)|(-3,4) |(-5,-12) |(-3,4) |(10,10) |(-3,4) |(0,0) |(5.1,34.5) |(-10,0) |(5.1,34.5) |(-3,4) |(5.1,34.5) |(-5,-12) |(5.1,34.5) |(10,10) |(5.1,34.5) |(0,0) |(-5,-12) |(-10,0) |(-5,-12) |(-3,4) |(-5,-12) |(5.1,34.5)|(-5,-12) |(10,10) |(-5,-12) |(0,0) |(10,10) |(-10,0) |(10,10) |(-3,4) |(10,10) |(5.1,34.5)|(10,10) |(-5,-12) |(10,10) (30 rows) QUERY: SELECT '' AS fifteen, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 ORDER BY distance; fifteen|point1 |point2 | distance -------+----------+----------+---------------- |(-3,4) |(0,0) | 5 |(-10,0) |(-3,4) |8.06225774829855 |(-10,0) |(0,0) | 10 |(-5,-12) |(0,0) | 13 |(-10,0) |(-5,-12) | 13 |(0,0) |(10,10) | 14.142135623731 |(-3,4) |(10,10) |14.3178210632764 |(-5,-12) |(-3,4) |16.1245154965971 |(-10,0) |(10,10) |22.3606797749979 |(5.1,34.5)|(10,10) |24.9851956166046 |(-5,-12) |(10,10) |26.6270539113887 |(-3,4) |(5.1,34.5)|31.5572495632937 |(0,0) |(5.1,34.5)|34.8749193547455 |(-10,0) |(5.1,34.5)|37.6597928831267 |(-5,-12) |(5.1,34.5)|47.5842410888311 (15 rows) QUERY: SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1 ORDER BY distance; three|point1 |point2 | distance -----+----------+--------+---------------- |(-3,4) |(0,0) | 5 |(-10,0) |(-5,-12)| 13 |(5.1,34.5)|(10,10) |24.9851956166046 (3 rows) QUERY: RESET geqo;