point.out 6.85 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13
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'
14 15 16 17 18 19 20 21 22 23
QUERY: SELECT '' AS six, POINT_TBL.*;
six|f1        
---+----------
   |(0,0)     
   |(-10,0)   
   |(-3,4)    
   |(5.1,34.5)
   |(-5,-12)  
   |(10,10)   
(6 rows)
24

25
QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 << '(0.0, 0.0)';
26 27 28 29 30 31 32
three|f1      
-----+--------
     |(-10,0) 
     |(-3,4)  
     |(-5,-12)
(3 rows)

33
QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >> p.f1;
34 35 36 37 38 39 40
three|f1      
-----+--------
     |(-10,0) 
     |(-3,4)  
     |(-5,-12)
(3 rows)

41
QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >^ p.f1;
42 43 44 45 46
one|f1      
---+--------
   |(-5,-12)
(1 row)

47
QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 <^ '(0.0, 0.0)';
48 49 50 51 52
one|f1      
---+--------
   |(-5,-12)
(1 row)

53
QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 ~= '(5.1, 34.5)';
54 55 56 57 58
one|f1        
---+----------
   |(5.1,34.5)
(1 row)

59
QUERY: SELECT '' AS three, p.* FROM POINT_TBL p
60
   WHERE p.f1 @ '(0,0,100,100)'::box;
61 62 63 64 65 66
three|f1        
-----+----------
     |(0,0)     
     |(5.1,34.5)
     |(10,10)   
(3 rows)
67 68

QUERY: SELECT '' AS three, p.* FROM POINT_TBL p
69
   WHERE not p.f1 @ '(0,0,100,100)'::box;
70 71 72 73 74 75 76 77
three|f1      
-----+--------
     |(-10,0) 
     |(-3,4)  
     |(-5,-12)
(3 rows)

QUERY: SELECT '' AS two, p.* FROM POINT_TBL p
78
   WHERE p.f1 @ '[(0,0),(-10,0),(-10,10)]'::path;
79 80 81 82 83 84
two|f1     
---+-------
   |(0,0)  
   |(-10,0)
(2 rows)

85
QUERY: SELECT '' AS six, p.f1, p.f1 <-> '(0,0)'::point AS dist
86 87
   FROM POINT_TBL p
   ORDER BY dist;
88 89 90 91
six|f1        |            dist
---+----------+----------------
   |(0,0)     |               0
   |(-3,4)    |               5
92
   |(-10,0)   |              10
93 94
   |(-5,-12)  |              13
   |(10,10)   | 14.142135623731
95
   |(5.1,34.5)|34.8749193547455
96
(6 rows)
97

98
QUERY: SET geqo TO 'off';
99
QUERY: SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist
100 101 102
   FROM POINT_TBL p1, POINT_TBL p2
   ORDER BY dist;
thirtysix|point1    |point2    |            dist
103
---------+----------+----------+----------------
104 105 106 107 108
         |(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
109
         |(0,0)     |(0,0)     |               0
110
         |(0,0)     |(-3,4)    |               5
111
         |(-3,4)    |(0,0)     |               5
112
         |(-10,0)   |(-3,4)    |8.06225774829855
113
         |(-3,4)    |(-10,0)   |8.06225774829855
114 115 116 117 118
         |(-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
119
         |(-5,-12)  |(-10,0)   |              13
120 121 122 123 124 125 126
         |(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
127
         |(10,10)   |(-10,0)   |22.3606797749979
128 129 130 131 132
         |(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
133
         |(5.1,34.5)|(-3,4)    |31.5572495632937
134
         |(5.1,34.5)|(0,0)     |34.8749193547455
135 136
         |(0,0)     |(5.1,34.5)|34.8749193547455
         |(-10,0)   |(5.1,34.5)|37.6597928831267
137
         |(5.1,34.5)|(-10,0)   |37.6597928831267
138 139 140
         |(-5,-12)  |(5.1,34.5)|47.5842410888311
         |(5.1,34.5)|(-5,-12)  |47.5842410888311
(36 rows)
141

142
QUERY: SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2
143
   FROM POINT_TBL p1, POINT_TBL p2
144
   WHERE (p1.f1 <-> p2.f1) > 3;
145
thirty|point1    |point2    
146 147 148 149 150
------+----------+----------
      |(-10,0)   |(0,0)     
      |(-3,4)    |(0,0)     
      |(5.1,34.5)|(0,0)     
      |(-5,-12)  |(0,0)     
151
      |(10,10)   |(0,0)     
152 153 154 155
      |(0,0)     |(-10,0)   
      |(-3,4)    |(-10,0)   
      |(5.1,34.5)|(-10,0)   
      |(-5,-12)  |(-10,0)   
156
      |(10,10)   |(-10,0)   
157 158 159 160
      |(0,0)     |(-3,4)    
      |(-10,0)   |(-3,4)    
      |(5.1,34.5)|(-3,4)    
      |(-5,-12)  |(-3,4)    
161
      |(10,10)   |(-3,4)    
162 163 164 165
      |(0,0)     |(5.1,34.5)
      |(-10,0)   |(5.1,34.5)
      |(-3,4)    |(5.1,34.5)
      |(-5,-12)  |(5.1,34.5)
166
      |(10,10)   |(5.1,34.5)
167 168 169 170
      |(0,0)     |(-5,-12)  
      |(-10,0)   |(-5,-12)  
      |(-3,4)    |(-5,-12)  
      |(5.1,34.5)|(-5,-12)  
171 172 173 174 175 176 177
      |(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)
178

179
QUERY: SELECT '' AS fifteen, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
180
   FROM POINT_TBL p1, POINT_TBL p2
181
   WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1
182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199
   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
200
(15 rows)
201

202
QUERY: SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
203
   FROM POINT_TBL p1, POINT_TBL p2
204
   WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1
205 206 207 208 209 210
   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
211
(3 rows)
212

213
QUERY: RESET geqo;