text.out

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

-------
   401
(1 row)

SELECT count(*) FROM texttmp WHERE a >   '31b0';
 count 
-------
   400
(1 row)

CREATE INDEX textidx ON texttmp USING GIST ( a );
SET enable_seqscan=off;
SELECT count(*) FROM texttmp WHERE a <   '31b0'::text;
 count 
-------
   588
(1 row)

SELECT count(*) FROM texttmp WHERE a <=  '31b0'::text;
 count 
-------
   589
(1 row)

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