summaryrefslogtreecommitdiffstats
path: root/contrib/btree_gist/expected/date.out
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-13 13:44:03 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-13 13:44:03 +0000
commit293913568e6a7a86fd1479e1cff8e2ecb58d6568 (patch)
treefc3b469a3ec5ab71b36ea97cc7aaddb838423a0c /contrib/btree_gist/expected/date.out
parentInitial commit. (diff)
downloadpostgresql-16-293913568e6a7a86fd1479e1cff8e2ecb58d6568.tar.xz
postgresql-16-293913568e6a7a86fd1479e1cff8e2ecb58d6568.zip
Adding upstream version 16.2.upstream/16.2
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'contrib/btree_gist/expected/date.out')
-rw-r--r--contrib/btree_gist/expected/date.out91
1 files changed, 91 insertions, 0 deletions
diff --git a/contrib/btree_gist/expected/date.out b/contrib/btree_gist/expected/date.out
new file mode 100644
index 0000000..5db864b
--- /dev/null
+++ b/contrib/btree_gist/expected/date.out
@@ -0,0 +1,91 @@
+-- date check
+CREATE TABLE datetmp (a date);
+\copy datetmp from 'data/date.data'
+SET enable_seqscan=on;
+SELECT count(*) FROM datetmp WHERE a < '2001-02-13';
+ count
+-------
+ 230
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a <= '2001-02-13';
+ count
+-------
+ 231
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a = '2001-02-13';
+ count
+-------
+ 1
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a >= '2001-02-13';
+ count
+-------
+ 314
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a > '2001-02-13';
+ count
+-------
+ 313
+(1 row)
+
+SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
+ a | ?column?
+------------+----------
+ 02-13-2001 | 0
+ 02-11-2001 | 2
+ 03-24-2001 | 39
+(3 rows)
+
+CREATE INDEX dateidx ON datetmp USING gist ( a );
+SET enable_seqscan=off;
+SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date;
+ count
+-------
+ 230
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date;
+ count
+-------
+ 231
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a = '2001-02-13'::date;
+ count
+-------
+ 1
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'::date;
+ count
+-------
+ 314
+(1 row)
+
+SELECT count(*) FROM datetmp WHERE a > '2001-02-13'::date;
+ count
+-------
+ 313
+(1 row)
+
+EXPLAIN (COSTS OFF)
+SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
+ QUERY PLAN
+------------------------------------------------
+ Limit
+ -> Index Only Scan using dateidx on datetmp
+ Order By: (a <-> '02-13-2001'::date)
+(3 rows)
+
+SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
+ a | ?column?
+------------+----------
+ 02-13-2001 | 0
+ 02-11-2001 | 2
+ 03-24-2001 | 39
+(3 rows)
+