bytea.sql

来自「PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统」· SQL 代码 · 共 35 行 · 第 1/3 页

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;