numeric.out

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

-- numeric check
CREATE TABLE numerictmp (a numeric);
\copy numerictmp from 'data/int8.data'
\copy numerictmp from 'data/numeric.data'
\copy numerictmp from 'data/float8.data'
SET enable_seqscan=on;
SELECT count(*) FROM numerictmp WHERE a <  -1890.0;
 count 
-------
   505
(1 row)

SELECT count(*) FROM numerictmp WHERE a <= -1890.0;
 count 
-------
   506
(1 row)

SELECT count(*) FROM numerictmp WHERE a  = -1890.0;
 count 
-------
     1
(1 row)

SELECT count(*) FROM numerictmp WHERE a >= -1890.0;
 count 
-------
   597
(1 row)

SELECT count(*) FROM numerictmp WHERE a >  -1890.0;
 count 
-------
   596
(1 row)

SELECT count(*) FROM numerictmp WHERE a <  'NaN' ;
 count 
-------
  1100
(1 row)

SELECT count(*) FROM numerictmp WHERE a <= 'NaN' ;
 count 
-------
  1102
(1 row)

SELECT count(*) FROM numerictmp WHERE a  = 'NaN' ;
 count 
-------
     2
(1 row)

SELECT count(*) FROM numerictmp WHERE a >= 'NaN' ;
 count 
-------
     2
(1 row)

SELECT count(*) FROM numerictmp WHERE a >  'NaN' ;
 count 
-------
     0
(1 row)

SELECT count(*) FROM numerictmp WHERE a <  0 ;
 count 
-------
   523
(1 row)

SELECT count(*) FROM numerictmp WHERE a <= 0 ;
 count 
-------
   526
(1 row)

SELECT count(*) FROM numerictmp WHERE a  = 0 ;
 count 
-------
     3
(1 row)

SELECT count(*) FROM numerictmp WHERE a >= 0 ;
 count 
-------
   579
(1 row)

SELECT count(*) FROM numerictmp WHERE a >  0 ;
 count 
-------
   576
(1 row)

CREATE INDEX numericidx ON numerictmp USING gist ( a );
SET enable_seqscan=off;
SELECT count(*) FROM numerictmp WHERE a <  -1890.0;
 count 
-------
   505
(1 row)

SELECT count(*) FROM numerictmp WHERE a <= -1890.0;
 count 
-------
   506
(1 row)

SELECT count(*) FROM numerictmp WHERE a  = -1890.0;
 count 
-------
     1
(1 row)

SELECT count(*) FROM numerictmp WHERE a >= -1890.0;
 count 
-------
   597
(1 row)

SELECT count(*) FROM numerictmp WHERE a >  -1890.0;
 count 
-------
   596
(1 row)

SELECT count(*) FROM numerictmp WHERE a <  'NaN' ;
 count 
-------
  1100
(1 row)

SELECT count(*) FROM numerictmp WHERE a <= 'NaN' ;
 count 
-------
  1102
(1 row)

SELECT count(*) FROM numerictmp WHERE a  = 'NaN' ;
 count 
-------
     2
(1 row)

SELECT count(*) FROM numerictmp WHERE a >= 'NaN' ;
 count 
-------
     2
(1 row)

SELECT count(*) FROM numerictmp WHERE a >  'NaN' ;
 count 
-------
     0
(1 row)

SELECT count(*) FROM numerictmp WHERE a <  0 ;
 count 
-------
   523
(1 row)

SELECT count(*) FROM numerictmp WHERE a <= 0 ;
 count 
-------
   526
(1 row)

SELECT count(*) FROM numerictmp WHERE a  = 0 ;
 count 
-------
     3
(1 row)

SELECT count(*) FROM numerictmp WHERE a >= 0 ;
 count 
-------
   579
(1 row)

SELECT count(*) FROM numerictmp WHERE a >  0 ;
 count 
-------
   576
(1 row)