contrib/btree_gin/expected/macaddr.out

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