contrib/btree_gin/expected/timetz.out

   1 set enable_seqscan=off;
   2 CREATE TABLE test_timetz (
   3         i timetz
   4 );
   5 INSERT INTO test_timetz VALUES
   6         ( '03:55:08 GMT+2' ),
   7         ( '04:55:08 GMT+2' ),
   8         ( '05:55:08 GMT+2' ),
   9         ( '08:55:08 GMT+2' ),
  10         ( '09:55:08 GMT+2' ),
  11         ( '10:55:08 GMT+2' )
  12 ;
  13 CREATE INDEX idx_timetz ON test_timetz USING gin (i);
  14 SELECT * FROM test_timetz WHERE i<'08:55:08 GMT+2'::timetz ORDER BY i;
  15       i
  16 -------------
  17  03:55:08-02
  18  04:55:08-02
  19  05:55:08-02
  20 (3 rows)
  21
  22 SELECT * FROM test_timetz WHERE i<='08:55:08 GMT+2'::timetz ORDER BY i;
  23       i
  24 -------------
  25  03:55:08-02
  26  04:55:08-02
  27  05:55:08-02
  28  08:55:08-02
  29 (4 rows)
  30
  31 SELECT * FROM test_timetz WHERE i='08:55:08 GMT+2'::timetz ORDER BY i;
  32       i
  33 -------------
  34  08:55:08-02
  35 (1 row)
  36
  37 SELECT * FROM test_timetz WHERE i>='08:55:08 GMT+2'::timetz ORDER BY i;
  38       i
  39 -------------
  40  08:55:08-02
  41  09:55:08-02
  42  10:55:08-02
  43 (3 rows)
  44
  45 SELECT * FROM test_timetz WHERE i>'08:55:08 GMT+2'::timetz ORDER BY i;
  46       i
  47 -------------
  48  09:55:08-02
  49  10:55:08-02
  50 (2 rows)
  51