2
CREATE TABLE vchartmp (a varchar(32));
3
\copy vchartmp from 'data/char.data'
5
SELECT count(*) FROM vchartmp WHERE a < '31b0'::varchar(32);
11
SELECT count(*) FROM vchartmp WHERE a <= '31b0'::varchar(32);
17
SELECT count(*) FROM vchartmp WHERE a = '31b0'::varchar(32);
23
SELECT count(*) FROM vchartmp WHERE a >= '31b0'::varchar(32);
29
SELECT count(*) FROM vchartmp WHERE a > '31b0'::varchar(32);
35
CREATE INDEX vcharidx ON vchartmp USING GIST ( text(a) );
36
SET enable_seqscan=off;
37
SELECT count(*) FROM vchartmp WHERE a < '31b0'::varchar(32);
43
SELECT count(*) FROM vchartmp WHERE a <= '31b0'::varchar(32);
49
SELECT count(*) FROM vchartmp WHERE a = '31b0'::varchar(32);
55
SELECT count(*) FROM vchartmp WHERE a >= '31b0'::varchar(32);
61
SELECT count(*) FROM vchartmp WHERE a > '31b0'::varchar(32);