varbit.sql

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

-- varbit check

CREATE TABLE varbittmp (a varbit);

\copy varbittmp from 'data/varbit.data'

SET enable_seqscan=on;

SELECT count(*) FROM varbittmp WHERE a <   '1110100111010';

SELECT count(*) FROM varbittmp WHERE a <=  '1110100111010';

SELECT count(*) FROM varbittmp WHERE a  =  '1110100111010';

SELECT count(*) FROM varbittmp WHERE a >=  '1110100111010';

SELECT count(*) FROM varbittmp WHERE a >   '1110100111010';

CREATE INDEX varbitidx ON varbittmp USING GIST ( a );

SET enable_seqscan=off;

SELECT count(*) FROM varbittmp WHERE a <   '1110100111010'::varbit;

SELECT count(*) FROM varbittmp WHERE a <=  '1110100111010'::varbit;

SELECT count(*) FROM varbittmp WHERE a  =  '1110100111010'::varbit;

SELECT count(*) FROM varbittmp WHERE a >=  '1110100111010'::varbit;

SELECT count(*) FROM varbittmp WHERE a >   '1110100111010'::varbit;