bytea.sql

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

SELECT count(*) FROM byteatmp WHERE a  =  '31b0';

SELECT count(*) FROM byteatmp WHERE a >=  '31b0';

SELECT count(*) FROM byteatmp WHERE a >   '31b0';

CREATE INDEX byteaidx ON byteatmp USING GIST ( a );

SET enable_seqscan=off;

SELECT count(*) FROM byteatmp WHERE a <   '31b0'::bytea;