create schema test_blob;
set current_schema to 'test_blob';
create table test_template (t tinyblob, b blob, m mediumblob, l longblob);
insert into test_template values('aaaaaaaaa', 'aaaaaaaaa', 'aaaaaaaaa', 'aaaaaaaaa');
create table test_tiny (t tinyblob);
create table test_blob (b blob);
create table test_medium (m mediumblob);
create table test_long (l longblob);
insert into test_tiny select t from test_template;
insert into test_tiny select b from test_template;
insert into test_tiny select m from test_template;
insert into test_tiny select l from test_template;
insert into test_blob select t from test_template;
insert into test_blob select b from test_template;
insert into test_blob select m from test_template;
insert into test_blob select l from test_template;
insert into test_medium select t from test_template;
insert into test_medium select b from test_template;
insert into test_medium select m from test_template;
insert into test_medium select l from test_template;
insert into test_long select t from test_template;
insert into test_long select b from test_template;
insert into test_long select m from test_template;
insert into test_long select l from test_template;
\COPY test_template to './test_template.data';
create table test_template2 (t tinyblob, b blob, m mediumblob, l longblob);
\COPY test_template2 from './test_template.data';
truncate test_tiny;
truncate test_blob;
truncate test_medium;
truncate test_long;
insert into test_tiny values('ppp');
insert into test_blob values('ppp');
insert into test_medium values('ppp');
insert into test_long values('ppp');
set dolphin.b_compatibility_mode = true;
set bytea_output = 'escape';
insert into test_blob values('ppp');
select * from test_tiny;
  t  
-----
 ppp
(1 row)

select * from test_blob;
  b  
-----
 ppp
 ppp
(2 rows)

select * from test_medium;
  m  
-----
 ppp
(1 row)

select * from test_long;
  l  
-----
 ppp
(1 row)

set dolphin.b_compatibility_mode = false;
select * from test_blob;
   b    
--------
 707070
 707070
(2 rows)

drop table test_template;
drop table test_template2;
drop table test_tiny;
drop table test_blob;
drop table test_medium;
drop table test_long;
set dolphin.b_compatibility_mode to on;
SELECT 'ab'::blob = 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob = 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob = 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob = 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob > 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob > 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob > 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob > 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob >= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob >= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob >= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob >= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob < 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob < 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob < 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob < 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob <= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob <= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob <= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob <= 'ab';
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob <> 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob <> 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob <> 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob <> 'ab';
 ?column? 
----------
 f
(1 row)

SELECT 'ab' = 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' = 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'= 'ab'::mediumblob ;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' = 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' > 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' > 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'> 'ab'::mediumblob ;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' > 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' >= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' >= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'>= 'ab'::mediumblob ;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' >= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' < 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' < 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'< 'ab'::mediumblob ;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' < 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' <= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' <= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'<= 'ab'::mediumblob ;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' <= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab' <> 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' <> 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'<> 'ab'::mediumblob ;
 ?column? 
----------
 f
(1 row)

SELECT 'ab' <> 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob = 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob = 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob = 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob = 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw = 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw = 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw = 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw = 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob = 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob = 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob = 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob = 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob = 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob = 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob = 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob = 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob = 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob = 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob = 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob = 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob = 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob = 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob = 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob = 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob < 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob < 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob < 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob < 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw < 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw < 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw < 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw < 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob < 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob < 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob < 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob < 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob < 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob < 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob < 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob < 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob < 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob < 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob < 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob < 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob < 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob < 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob < 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob < 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob <= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob <= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob <= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob <= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw <= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw <= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw <= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw <= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob <= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob <= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob <= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob <= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob <= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob <= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob <= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob <= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob <= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob <= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob <= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob <= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob <= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob <= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob <= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob <= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob >= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob >= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob >= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob >= 'ab'::raw;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw >= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw >= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw >= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::raw >= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob >= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob >= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob >= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob >= 'ab'::blob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob >= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob >= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob >= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob >= 'ab'::tinyblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob >= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob >= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob >= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob >= 'ab'::mediumblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob >= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::tinyblob >= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::mediumblob >= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::longblob >= 'ab'::longblob;
 ?column? 
----------
 t
(1 row)

SELECT 'ab'::blob > 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob > 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob > 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob > 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw > 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw > 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw > 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw > 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob > 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob > 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob > 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob > 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob > 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob > 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob > 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob > 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob > 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob > 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob > 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob > 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob > 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob > 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob > 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob > 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob <> 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob <> 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob <> 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob <> 'ab'::raw;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw <> 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw <> 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw <> 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::raw <> 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob <> 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob <> 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob <> 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob <> 'ab'::blob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob <> 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob <> 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob <> 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob <> 'ab'::tinyblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob <> 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob <> 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob <> 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob <> 'ab'::mediumblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::blob <> 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::tinyblob <> 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::mediumblob <> 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

SELECT 'ab'::longblob <> 'ab'::longblob;
 ?column? 
----------
 f
(1 row)

create table t_dezebium_0007_02(c1 tinyblob,
c2 mediumblob,
c3 longblob,
c4 blob,
c5 binary(5),
c23 varbinary(50))default charset=utf8;
insert t_dezebium_0007_02 values('1010101','1010101','1010101','1010101','ab','ab');
select * from t_dezebium_0007_02;
   c1    |   c2    |   c3    |   c4    |       c5       | c23 
---------+---------+---------+---------+----------------+-----
 1010101 | 1010101 | 1010101 | 1010101 | ab\000\000\000 | ab
(1 row)

set bytea_output=escape;
select * from t_dezebium_0007_02;
   c1    |   c2    |   c3    |   c4    |       c5       | c23 
---------+---------+---------+---------+----------------+-----
 1010101 | 1010101 | 1010101 | 1010101 | ab\000\000\000 | ab
(1 row)

update t_dezebium_0007_02 set c2='101',c5='FG';
delete from t_dezebium_0007_02 where hex(c23)=6162;
DROP TABLE IF EXISTS t_index_test;
NOTICE:  table "t_index_test" does not exist, skipping
create table t_index_test(a blob, b tinyblob, c mediumblob, d longblob);
insert into t_index_test select i,i,i,i from generate_series(1,10000) i;
create index i_a on t_index_test(a);
create index i_b on t_index_test(b);
create index i_c on t_index_test(c);
create index i_d on t_index_test(d);
analyze t_index_test;
explain (costs off) select * from t_index_test where a='1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_a on t_index_test
   Index Cond: (a = '1'::blob)
(3 rows)

explain (costs off) select * from t_index_test where a>='a1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_a on t_index_test
   Index Cond: (a >= 'a1'::blob)
(3 rows)

explain (costs off) select * from t_index_test where a>'a1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_a on t_index_test
   Index Cond: (a > 'a1'::blob)
(3 rows)

explain (costs off) select * from t_index_test where a<='0';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_a on t_index_test
   Index Cond: (a <= '0'::blob)
(3 rows)

explain (costs off) select * from t_index_test where a<'1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_a on t_index_test
   Index Cond: (a < '1'::blob)
(3 rows)

explain (costs off) select * from t_index_test where b='1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_b on t_index_test
   Index Cond: (b = '1'::tinyblob)
(3 rows)

explain (costs off) select * from t_index_test where b>='a1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_b on t_index_test
   Index Cond: (b >= 'a1'::tinyblob)
(3 rows)

explain (costs off) select * from t_index_test where b>'a1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_b on t_index_test
   Index Cond: (b > 'a1'::tinyblob)
(3 rows)

explain (costs off) select * from t_index_test where b<='0';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_b on t_index_test
   Index Cond: (b <= '0'::tinyblob)
(3 rows)

explain (costs off) select * from t_index_test where b<'1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_b on t_index_test
   Index Cond: (b < '1'::tinyblob)
(3 rows)

explain (costs off) select * from t_index_test where c='1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_c on t_index_test
   Index Cond: (c = '1'::mediumblob)
(3 rows)

explain (costs off) select * from t_index_test where c>='a1';
              QUERY PLAN               
---------------------------------------
 [Bypass]
 Index Scan using i_c on t_index_test
   Index Cond: (c >= 'a1'::mediumblob)
(3 rows)

explain (costs off) select * from t_index_test where c>'a1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_c on t_index_test
   Index Cond: (c > 'a1'::mediumblob)
(3 rows)

explain (costs off) select * from t_index_test where c<='0';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_c on t_index_test
   Index Cond: (c <= '0'::mediumblob)
(3 rows)

explain (costs off) select * from t_index_test where c<'1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_c on t_index_test
   Index Cond: (c < '1'::mediumblob)
(3 rows)

explain (costs off) select * from t_index_test where d='1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_d on t_index_test
   Index Cond: (d = '1'::longblob)
(3 rows)

explain (costs off) select * from t_index_test where d>='a1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_d on t_index_test
   Index Cond: (d >= 'a1'::longblob)
(3 rows)

explain (costs off) select * from t_index_test where d>'a1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_d on t_index_test
   Index Cond: (d > 'a1'::longblob)
(3 rows)

explain (costs off) select * from t_index_test where d<='0';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_d on t_index_test
   Index Cond: (d <= '0'::longblob)
(3 rows)

explain (costs off) select * from t_index_test where d<'1';
              QUERY PLAN              
--------------------------------------
 [Bypass]
 Index Scan using i_d on t_index_test
   Index Cond: (d < '1'::longblob)
(3 rows)

drop index i_a;
drop index i_b;
drop index i_c;
drop index i_d;
create index i_a on t_index_test(a) using hash;
create index i_b on t_index_test(b) using hash;
create index i_c on t_index_test(c) using hash;
create index i_d on t_index_test(d) using hash;
analyze t_index_test;
explain (costs off) select * from t_index_test where a='1';
              QUERY PLAN              
--------------------------------------
 Index Scan using i_a on t_index_test
   Index Cond: (a = '1'::blob)
(2 rows)

explain (costs off) select * from t_index_test where b='1';
              QUERY PLAN              
--------------------------------------
 Index Scan using i_b on t_index_test
   Index Cond: (b = '1'::tinyblob)
(2 rows)

explain (costs off) select * from t_index_test where c='1';
              QUERY PLAN              
--------------------------------------
 Index Scan using i_c on t_index_test
   Index Cond: (c = '1'::mediumblob)
(2 rows)

explain (costs off) select * from t_index_test where d='1';
              QUERY PLAN              
--------------------------------------
 Index Scan using i_d on t_index_test
   Index Cond: (d = '1'::longblob)
(2 rows)

DROP TABLE t_index_test;
drop schema test_blob cascade;
NOTICE:  drop cascades to table t_dezebium_0007_02
reset current_schema;