text.sql

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

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

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

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

CREATE INDEX textidx ON texttmp USING GIST ( a );

SET enable_seqscan=off;

SELECT count(*) FROM texttmp WHERE a <   '31b0'::text;