1-- char check 2 3CREATE TABLE chartmp (a char(32)); 4 5\copy chartmp from 'data/char.data' 6 7SET enable_seqscan=on; 8 9SELECT count(*) FROM chartmp WHERE a < '31b0'::char(32); 10 11SELECT count(*) FROM chartmp WHERE a <= '31b0'::char(32); 12 13SELECT count(*) FROM chartmp WHERE a = '31b0'::char(32); 14 15SELECT count(*) FROM chartmp WHERE a >= '31b0'::char(32); 16 17SELECT count(*) FROM chartmp WHERE a > '31b0'::char(32); 18 19CREATE INDEX charidx ON chartmp USING GIST ( a ); 20 21SET enable_seqscan=off; 22 23SELECT count(*) FROM chartmp WHERE a < '31b0'::char(32); 24 25SELECT count(*) FROM chartmp WHERE a <= '31b0'::char(32); 26 27SELECT count(*) FROM chartmp WHERE a = '31b0'::char(32); 28 29SELECT count(*) FROM chartmp WHERE a >= '31b0'::char(32); 30 31SELECT count(*) FROM chartmp WHERE a > '31b0'::char(32); 32 33-- Test index-only scans 34SET enable_bitmapscan=off; 35EXPLAIN (COSTS OFF) 36SELECT * FROM chartmp WHERE a BETWEEN '31a' AND '31c'; 37SELECT * FROM chartmp WHERE a BETWEEN '31a' AND '31c'; 38