varchar.sql

set enable_seqscan=off;

CREATETABLEtest_varchar (
 i varchar
);

INSERT INTO test_varchar VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');

CREATEINDEXidx_varcharON test_varchar USING rum (i);

SELECT*FROM test_varchar WHERE i<'abc'::varcharORDER BY i;
SELECT*FROM test_varchar WHERE i<='abc'::varcharORDER BY i;
SELECT*FROM test_varchar WHERE i='abc'::varcharORDER BY i;
SELECT*FROM test_varchar WHERE i>='abc'::varcharORDER BY i;
SELECT*FROM test_varchar WHERE i>'abc'::varcharORDER BY i;