3
CREATE TABLE chartmp (a char(32));
5
\copy chartmp from 'data/char.data'
9
SELECT count(*) FROM chartmp WHERE a < '31b0'::char(32);
11
SELECT count(*) FROM chartmp WHERE a <= '31b0'::char(32);
13
SELECT count(*) FROM chartmp WHERE a = '31b0'::char(32);
15
SELECT count(*) FROM chartmp WHERE a >= '31b0'::char(32);
17
SELECT count(*) FROM chartmp WHERE a > '31b0'::char(32);
19
CREATE INDEX charidx ON chartmp USING GIST ( a );
21
SET enable_seqscan=off;
23
SELECT count(*) FROM chartmp WHERE a < '31b0'::char(32);
25
SELECT count(*) FROM chartmp WHERE a <= '31b0'::char(32);
27
SELECT count(*) FROM chartmp WHERE a = '31b0'::char(32);
29
SELECT count(*) FROM chartmp WHERE a >= '31b0'::char(32);
31
SELECT count(*) FROM chartmp WHERE a > '31b0'::char(32);