@@ -184,7 +184,22 @@ SELECT id, d, d |-> '2016-05-16 14:21:25' FROM tsts WHERE t @@ 'wr&qh' ORDER BY
184
184
457 | Fri May 20 20:21:22.326724 2016 | 367197.326724
185
185
(5 rows)
186
186
187
- --to be fixed
188
- --EXPLAIN (costs off)
189
- --SELECT id, d, d <-> '2016-05-16 14:21:25' FROM tsts ORDER BY d <-> '2016-05-16 14:21:25' LIMIT 5;
190
- --SELECT id, d, d <-> '2016-05-16 14:21:25' FROM tsts ORDER BY d <-> '2016-05-16 14:21:25' LIMIT 5;
187
+ EXPLAIN (costs off)
188
+ SELECT id, d, d <-> '2016-05-16 14:21:25' FROM tsts ORDER BY d <-> '2016-05-16 14:21:25' LIMIT 5;
189
+ QUERY PLAN
190
+ -----------------------------------------------------------------------------------
191
+ Limit
192
+ -> Index Scan using tsts_idx on tsts
193
+ Order By: (d <-> 'Mon May 16 14:21:25 2016'::timestamp without time zone)
194
+ (3 rows)
195
+
196
+ SELECT id, d, d <-> '2016-05-16 14:21:25' FROM tsts ORDER BY d <-> '2016-05-16 14:21:25' LIMIT 5;
197
+ id | d | ?column?
198
+ -----+---------------------------------+----------
199
+ 355 | Mon May 16 14:21:22.326724 2016 | 2.673276
200
+ 355 | Mon May 16 14:21:22.326724 2016 | 2.673276
201
+ 355 | Mon May 16 14:21:22.326724 2016 | 2.673276
202
+ 355 | Mon May 16 14:21:22.326724 2016 | 2.673276
203
+ 355 | Mon May 16 14:21:22.326724 2016 | 2.673276
204
+ (5 rows)
205
+