diff options
Diffstat (limited to 'src/test/regress/expected/arrays.out')
| -rw-r--r-- | src/test/regress/expected/arrays.out | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/src/test/regress/expected/arrays.out b/src/test/regress/expected/arrays.out new file mode 100644 index 0000000000..b593c212cb --- /dev/null +++ b/src/test/regress/expected/arrays.out @@ -0,0 +1,61 @@ +QUERY: SELECT * FROM arrtest; +a |b |c |d |e +-----------+---------------+-------------+-----------------+------------- +{1,2,3,4,5}|{{{0,0},{1,2}}}|{} |{} | +{11,12,23} |{{3,4},{4,5}} |{"foobar"} |{{"elt1","elt2"}}|{"3.4","6.7"} +{} |{3,4} |{"foo","bar"}|{"bar","foo"} | +(3 rows) + +QUERY: SELECT arrtest.a[1], + arrtest.b[1][1][1], + arrtest.c[1], + arrtest.d[1][1], + arrtest.e[0] + FROM arrtest; + a|b|c |d |e +--+-+------+----+- + 1|0| | | +11| |foobar|elt1| + | |foo | | +(3 rows) + +QUERY: SELECT arrtest.a[1:3], + arrtest.b[1:1][1:2][1:2], + arrtest.c[1:2], + arrtest.d[1:1][1:2] + FROM arrtest; +a |b |c |d +----------+---------------+-------------+----------------- +{1,2,3} |{{{0,0},{1,2}}}| | +{11,12,23}| | |{{"elt1","elt2"}} + | |{"foo","bar"}| +(3 rows) + +QUERY: SELECT array_dims(arrtest.b) AS x; +x +--------------- +[1:1][1:2][1:2] +[1:2][1:2] +[1:2] +(3 rows) + +QUERY: SELECT * + FROM arrtest + WHERE arrtest.a[1] < 5 and + arrtest.c = '{"foobar"}'::_char16; +a|b|c|d|e +-+-+-+-+- +(0 rows) + +QUERY: SELECT arrtest.a[1:3], + arrtest.b[1:1][1:2][1:2], + arrtest.c[1:2], + arrtest.d[1:1][1:2] + FROM arrtest; +a |b |c |d +----------+---------------+-------------+----------------- +{1,2,3} |{{{0,0},{1,2}}}| | +{11,12,23}| | |{{"elt1","elt2"}} + | |{"foo","bar"}| +(3 rows) + |