3
CREATE TABLE float8tmp (a float8);
5
\copy float8tmp from 'data/float8.data'
9
SELECT count(*) FROM float8tmp WHERE a < -1890.0;
11
SELECT count(*) FROM float8tmp WHERE a <= -1890.0;
13
SELECT count(*) FROM float8tmp WHERE a = -1890.0;
15
SELECT count(*) FROM float8tmp WHERE a >= -1890.0;
17
SELECT count(*) FROM float8tmp WHERE a > -1890.0;
19
CREATE INDEX float8idx ON float8tmp USING gist ( a );
21
SET enable_seqscan=off;
23
SELECT count(*) FROM float8tmp WHERE a < -1890.0::float8;
25
SELECT count(*) FROM float8tmp WHERE a <= -1890.0::float8;
27
SELECT count(*) FROM float8tmp WHERE a = -1890.0::float8;
29
SELECT count(*) FROM float8tmp WHERE a >= -1890.0::float8;
31
SELECT count(*) FROM float8tmp WHERE a > -1890.0::float8;