3
CREATE TABLE numerictmp (a numeric);
5
\copy numerictmp from 'data/int8.data'
6
\copy numerictmp from 'data/numeric.data'
7
\copy numerictmp from 'data/float8.data'
11
SELECT count(*) FROM numerictmp WHERE a < -1890.0;
13
SELECT count(*) FROM numerictmp WHERE a <= -1890.0;
15
SELECT count(*) FROM numerictmp WHERE a = -1890.0;
17
SELECT count(*) FROM numerictmp WHERE a >= -1890.0;
19
SELECT count(*) FROM numerictmp WHERE a > -1890.0;
22
SELECT count(*) FROM numerictmp WHERE a < 'NaN' ;
24
SELECT count(*) FROM numerictmp WHERE a <= 'NaN' ;
26
SELECT count(*) FROM numerictmp WHERE a = 'NaN' ;
28
SELECT count(*) FROM numerictmp WHERE a >= 'NaN' ;
30
SELECT count(*) FROM numerictmp WHERE a > 'NaN' ;
32
SELECT count(*) FROM numerictmp WHERE a < 0 ;
34
SELECT count(*) FROM numerictmp WHERE a <= 0 ;
36
SELECT count(*) FROM numerictmp WHERE a = 0 ;
38
SELECT count(*) FROM numerictmp WHERE a >= 0 ;
40
SELECT count(*) FROM numerictmp WHERE a > 0 ;
43
CREATE INDEX numericidx ON numerictmp USING gist ( a );
45
SET enable_seqscan=off;
47
SELECT count(*) FROM numerictmp WHERE a < -1890.0;
49
SELECT count(*) FROM numerictmp WHERE a <= -1890.0;
51
SELECT count(*) FROM numerictmp WHERE a = -1890.0;
53
SELECT count(*) FROM numerictmp WHERE a >= -1890.0;
55
SELECT count(*) FROM numerictmp WHERE a > -1890.0;
58
SELECT count(*) FROM numerictmp WHERE a < 'NaN' ;
60
SELECT count(*) FROM numerictmp WHERE a <= 'NaN' ;
62
SELECT count(*) FROM numerictmp WHERE a = 'NaN' ;
64
SELECT count(*) FROM numerictmp WHERE a >= 'NaN' ;
66
SELECT count(*) FROM numerictmp WHERE a > 'NaN' ;
69
SELECT count(*) FROM numerictmp WHERE a < 0 ;
71
SELECT count(*) FROM numerictmp WHERE a <= 0 ;
73
SELECT count(*) FROM numerictmp WHERE a = 0 ;
75
SELECT count(*) FROM numerictmp WHERE a >= 0 ;
77
SELECT count(*) FROM numerictmp WHERE a > 0 ;