@@ -184,7 +184,22 @@ SELECT id, d, d |-> '2016-05-16 14:21:25' FROM tsts WHERE t @@ 'wr&qh' ORDER BY
184184 457 | Fri May 20 20:21:22.326724 2016 | 367197.326724
185185(5 rows)
186186
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+