diff options
| author | Bruce Momjian | 2002-09-12 00:14:40 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2002-09-12 00:14:40 +0000 |
| commit | 6fff9a7475f6ff26145e58dfeb91f0721e564b80 (patch) | |
| tree | 5f4988aa2c079df086c69f587ebb7674bb9cf97c /contrib/tablefunc/data | |
| parent | 6309033b16c9c009543c87c150bc52a4727dda40 (diff) | |
The attached removes the current non-standard file
"contrib/tablefunc/tablefunc-test.sql", and adds a standard regression
test suite to contrib/tablefunc.
Joe Conway
Diffstat (limited to 'contrib/tablefunc/data')
| -rw-r--r-- | contrib/tablefunc/data/connectby_int.data | 9 | ||||
| -rw-r--r-- | contrib/tablefunc/data/connectby_text.data | 9 | ||||
| -rw-r--r-- | contrib/tablefunc/data/ct.data | 14 |
3 files changed, 32 insertions, 0 deletions
diff --git a/contrib/tablefunc/data/connectby_int.data b/contrib/tablefunc/data/connectby_int.data new file mode 100644 index 00000000000..c061be3f069 --- /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 00000000000..30697c85b33 --- /dev/null +++ b/contrib/tablefunc/data/connectby_text.data @@ -0,0 +1,9 @@ +row1 \N +row2 row1 +row3 row1 +row4 row2 +row5 row2 +row6 row4 +row7 row3 +row8 row6 +row9 row5 diff --git a/contrib/tablefunc/data/ct.data b/contrib/tablefunc/data/ct.data new file mode 100644 index 00000000000..eb91cc9b3ae --- /dev/null +++ b/contrib/tablefunc/data/ct.data @@ -0,0 +1,14 @@ +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 |