summaryrefslogtreecommitdiffstats
path: root/contrib/tablefunc/data
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/tablefunc/data
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/tablefunc/data')
-rw-r--r--contrib/tablefunc/data/connectby_int.data9
-rw-r--r--contrib/tablefunc/data/connectby_text.data9
-rw-r--r--contrib/tablefunc/data/ct.data18
3 files changed, 36 insertions, 0 deletions
diff --git a/contrib/tablefunc/data/connectby_int.data b/contrib/tablefunc/data/connectby_int.data
new file mode 100644
index 0000000..c061be3
--- /dev/null
+++ b/contrib/tablefunc/data/connectby_int.data
@@ -0,0 +1,9 @@
+1 \N
+2 1
+3 1
+4 2
+5 2
+6 4
+7 3
+8 6
+9 5
diff --git a/contrib/tablefunc/data/connectby_text.data b/contrib/tablefunc/data/connectby_text.data
new file mode 100644
index 0000000..a903820
--- /dev/null
+++ b/contrib/tablefunc/data/connectby_text.data
@@ -0,0 +1,9 @@
+row1 \N 0
+row2 row1 0
+row3 row1 0
+row4 row2 1
+row5 row2 0
+row6 row4 0
+row7 row3 0
+row8 row6 0
+row9 row5 0
diff --git a/contrib/tablefunc/data/ct.data b/contrib/tablefunc/data/ct.data
new file mode 100644
index 0000000..7733fc2
--- /dev/null
+++ b/contrib/tablefunc/data/ct.data
@@ -0,0 +1,18 @@
+1 group1 test1 att1 val1
+2 group1 test1 att2 val2
+3 group1 test1 att3 val3
+4 group1 test1 att4 val4
+5 group1 test2 att1 val5
+6 group1 test2 att2 val6
+7 group1 test2 att3 val7
+8 group1 test2 att4 val8
+9 group2 test3 att1 val1
+10 group2 test3 att2 val2
+11 group2 test3 att3 val3
+12 group2 test4 att1 val4
+13 group2 test4 att2 val5
+14 group2 test4 att3 val6
+15 group1 \N att1 val9
+16 group1 \N att2 val10
+17 group1 \N att3 val11
+18 group1 \N att4 val12