1-- float4 check
2
3CREATE TABLE float4tmp (a float4);
4
5\copy float4tmp from 'data/float4.data'
6
7SET enable_seqscan=on;
8
9SELECT count(*) FROM float4tmp WHERE a <  -179.0;
10
11SELECT count(*) FROM float4tmp WHERE a <= -179.0;
12
13SELECT count(*) FROM float4tmp WHERE a  = -179.0;
14
15SELECT count(*) FROM float4tmp WHERE a >= -179.0;
16
17SELECT count(*) FROM float4tmp WHERE a >  -179.0;
18
19SELECT a, a <-> '-179.0' FROM float4tmp ORDER BY a <-> '-179.0' LIMIT 3;
20
21CREATE INDEX float4idx ON float4tmp USING gist ( a );
22
23SET enable_seqscan=off;
24
25SELECT count(*) FROM float4tmp WHERE a <  -179.0::float4;
26
27SELECT count(*) FROM float4tmp WHERE a <= -179.0::float4;
28
29SELECT count(*) FROM float4tmp WHERE a  = -179.0::float4;
30
31SELECT count(*) FROM float4tmp WHERE a >= -179.0::float4;
32
33SELECT count(*) FROM float4tmp WHERE a >  -179.0::float4;
34
35EXPLAIN (COSTS OFF)
36SELECT a, a <-> '-179.0' FROM float4tmp ORDER BY a <-> '-179.0' LIMIT 3;
37SELECT a, a <-> '-179.0' FROM float4tmp ORDER BY a <-> '-179.0' LIMIT 3;
38