1-- char check
2CREATE TABLE vchartmp (a varchar(32));
3\copy vchartmp from 'data/char.data'
4SET enable_seqscan=on;
5SELECT count(*) FROM vchartmp WHERE a <   '31b0'::varchar(32);
6 count
7-------
8   773
9(1 row)
10
11SELECT count(*) FROM vchartmp WHERE a <=  '31b0'::varchar(32);
12 count
13-------
14   774
15(1 row)
16
17SELECT count(*) FROM vchartmp WHERE a  =  '31b0'::varchar(32);
18 count
19-------
20     1
21(1 row)
22
23SELECT count(*) FROM vchartmp WHERE a >=  '31b0'::varchar(32);
24 count
25-------
26   215
27(1 row)
28
29SELECT count(*) FROM vchartmp WHERE a >   '31b0'::varchar(32);
30 count
31-------
32   214
33(1 row)
34
35CREATE INDEX vcharidx ON vchartmp USING GIST ( text(a) );
36SET enable_seqscan=off;
37SELECT count(*) FROM vchartmp WHERE a <   '31b0'::varchar(32);
38 count
39-------
40   773
41(1 row)
42
43SELECT count(*) FROM vchartmp WHERE a <=  '31b0'::varchar(32);
44 count
45-------
46   774
47(1 row)
48
49SELECT count(*) FROM vchartmp WHERE a  =  '31b0'::varchar(32);
50 count
51-------
52     1
53(1 row)
54
55SELECT count(*) FROM vchartmp WHERE a >=  '31b0'::varchar(32);
56 count
57-------
58   215
59(1 row)
60
61SELECT count(*) FROM vchartmp WHERE a >   '31b0'::varchar(32);
62 count
63-------
64   214
65(1 row)
66
67