oid.out

来自「PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统」· OUT 代码 · 共 65 行

-- oid check
SET enable_seqscan=on;
SELECT count(*) FROM moneytmp WHERE oid <  ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   372
(1 row)

SELECT count(*) FROM moneytmp WHERE oid <= ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   373
(1 row)

SELECT count(*) FROM moneytmp WHERE oid  = ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
     1
(1 row)

SELECT count(*) FROM moneytmp WHERE oid >= ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   228
(1 row)

SELECT count(*) FROM moneytmp WHERE oid >  ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   227
(1 row)

CREATE INDEX oididx ON moneytmp USING gist ( oid );
SET enable_seqscan=off;
SELECT count(*) FROM moneytmp WHERE oid <  ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   372
(1 row)

SELECT count(*) FROM moneytmp WHERE oid <= ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   373
(1 row)

SELECT count(*) FROM moneytmp WHERE oid  = ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
     1
(1 row)

SELECT count(*) FROM moneytmp WHERE oid >= ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   228
(1 row)

SELECT count(*) FROM moneytmp WHERE oid >  ( SELECT oid FROM moneytmp WHERE a  = '22649.64' );
 count 
-------
   227
(1 row)