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