From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- contrib/btree_gist/sql/numeric.sql | 83 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 83 insertions(+) create mode 100644 contrib/btree_gist/sql/numeric.sql (limited to 'contrib/btree_gist/sql/numeric.sql') diff --git a/contrib/btree_gist/sql/numeric.sql b/contrib/btree_gist/sql/numeric.sql new file mode 100644 index 0000000..dbb2f2f --- /dev/null +++ b/contrib/btree_gist/sql/numeric.sql @@ -0,0 +1,83 @@ +-- 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; + +SELECT count(*) FROM numerictmp WHERE a <= -1890.0; + +SELECT count(*) FROM numerictmp WHERE a = -1890.0; + +SELECT count(*) FROM numerictmp WHERE a >= -1890.0; + +SELECT count(*) FROM numerictmp WHERE a > -1890.0; + + +SELECT count(*) FROM numerictmp WHERE a < 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a <= 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a = 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a >= 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a > 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a < 0 ; + +SELECT count(*) FROM numerictmp WHERE a <= 0 ; + +SELECT count(*) FROM numerictmp WHERE a = 0 ; + +SELECT count(*) FROM numerictmp WHERE a >= 0 ; + +SELECT count(*) FROM numerictmp WHERE a > 0 ; + + +CREATE INDEX numericidx ON numerictmp USING gist ( a ); + +SET enable_seqscan=off; + +SELECT count(*) FROM numerictmp WHERE a < -1890.0; + +SELECT count(*) FROM numerictmp WHERE a <= -1890.0; + +SELECT count(*) FROM numerictmp WHERE a = -1890.0; + +SELECT count(*) FROM numerictmp WHERE a >= -1890.0; + +SELECT count(*) FROM numerictmp WHERE a > -1890.0; + + +SELECT count(*) FROM numerictmp WHERE a < 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a <= 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a = 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a >= 'NaN' ; + +SELECT count(*) FROM numerictmp WHERE a > 'NaN' ; + + +SELECT count(*) FROM numerictmp WHERE a < 0 ; + +SELECT count(*) FROM numerictmp WHERE a <= 0 ; + +SELECT count(*) FROM numerictmp WHERE a = 0 ; + +SELECT count(*) FROM numerictmp WHERE a >= 0 ; + +SELECT count(*) FROM numerictmp WHERE a > 0 ; + +-- Test index-only scans +SET enable_bitmapscan=off; +EXPLAIN (COSTS OFF) +SELECT * FROM numerictmp WHERE a BETWEEN 1 AND 300 ORDER BY a; +SELECT * FROM numerictmp WHERE a BETWEEN 1 AND 300 ORDER BY a; -- cgit v1.2.3