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