summaryrefslogtreecommitdiffstats
path: root/contrib/btree_gist/expected/float8.out
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 12:15:05 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 12:15:05 +0000
commit46651ce6fe013220ed397add242004d764fc0153 (patch)
tree6e5299f990f88e60174a1d3ae6e48eedd2688b2b /contrib/btree_gist/expected/float8.out
parentInitial commit. (diff)
downloadpostgresql-14-46651ce6fe013220ed397add242004d764fc0153.tar.xz
postgresql-14-46651ce6fe013220ed397add242004d764fc0153.zip
Adding upstream version 14.5.upstream/14.5upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'contrib/btree_gist/expected/float8.out')
-rw-r--r--contrib/btree_gist/expected/float8.out91
1 files changed, 91 insertions, 0 deletions
diff --git a/contrib/btree_gist/expected/float8.out b/contrib/btree_gist/expected/float8.out
new file mode 100644
index 0000000..ebd0ef3
--- /dev/null
+++ b/contrib/btree_gist/expected/float8.out
@@ -0,0 +1,91 @@
+-- float8 check
+CREATE TABLE float8tmp (a float8);
+\copy float8tmp from 'data/float8.data'
+SET enable_seqscan=on;
+SELECT count(*) FROM float8tmp WHERE a < -1890.0;
+ count
+-------
+ 237
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a <= -1890.0;
+ count
+-------
+ 238
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a = -1890.0;
+ count
+-------
+ 1
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a >= -1890.0;
+ count
+-------
+ 307
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a > -1890.0;
+ count
+-------
+ 306
+(1 row)
+
+SELECT a, a <-> '-1890.0' FROM float8tmp ORDER BY a <-> '-1890.0' LIMIT 3;
+ a | ?column?
+--------------+--------------------
+ -1890 | 0
+ -2003.634512 | 113.63451200000009
+ -1769.73634 | 120.26366000000007
+(3 rows)
+
+CREATE INDEX float8idx ON float8tmp USING gist ( a );
+SET enable_seqscan=off;
+SELECT count(*) FROM float8tmp WHERE a < -1890.0::float8;
+ count
+-------
+ 237
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a <= -1890.0::float8;
+ count
+-------
+ 238
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a = -1890.0::float8;
+ count
+-------
+ 1
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a >= -1890.0::float8;
+ count
+-------
+ 307
+(1 row)
+
+SELECT count(*) FROM float8tmp WHERE a > -1890.0::float8;
+ count
+-------
+ 306
+(1 row)
+
+EXPLAIN (COSTS OFF)
+SELECT a, a <-> '-1890.0' FROM float8tmp ORDER BY a <-> '-1890.0' LIMIT 3;
+ QUERY PLAN
+-----------------------------------------------------
+ Limit
+ -> Index Only Scan using float8idx on float8tmp
+ Order By: (a <-> '-1890'::double precision)
+(3 rows)
+
+SELECT a, a <-> '-1890.0' FROM float8tmp ORDER BY a <-> '-1890.0' LIMIT 3;
+ a | ?column?
+--------------+--------------------
+ -1890 | 0
+ -2003.634512 | 113.63451200000009
+ -1769.73634 | 120.26366000000007
+(3 rows)
+