@@ -3919,9 +3919,9 @@ QUERY: COPY BINARY stud_emp FROM '_CWD_/stud_emp.data';
3919
3919
QUERY: SELECT * FROM stud_emp;
3920
3920
name |age|location |salary|manager|gpa|percent
3921
3921
-----+---+----------+------+-------+---+-------
3922
- jeff | 23|(8,7.7) | 600|sharon |3.5|
3923
- cim | 30|(10.5,4.7)| 400| |3.4|
3924
- linda| 19|(0.9,6.1) | 100| |2.9|
3922
+ jeff | 23|(8,7.7) | 600|sharon |3.5| 0
3923
+ cim | 30|(10.5,4.7)| 400| |3.4| 0
3924
+ linda| 19|(0.9,6.1) | 100| |2.9| 0
3925
3925
(3 rows)
3926
3926
3927
3927
QUERY: SELECT count(*) FROM onek;
@@ -6764,11 +6764,11 @@ xacttest
6764
6764
(63 rows)
6765
6765
6766
6766
QUERY: SELECT * FROM arrtest;
6767
- a |b |c |d |e
6768
- -----------+--------------------- +-------------+-----------------+-------------
6769
- {1,2,3,4,5}|{{{0,0}},{{ 1,2}}} |{} |{} |
6770
- {11,12,23} |{{{3},{4}},{{4},{ 5}}} |{"foobar"} |{{"elt1","elt2"}}|{"3.4","6.7"}
6771
- {} |{{{ 3,4},{0,0}}} |{"foo","bar"}|{{ "bar"},{ "foo"}} |
6767
+ a |b |c |d |e
6768
+ -----------+---------------+-------------+-----------------+-------------
6769
+ {1,2,3,4,5}|{{{0,0},{ 1,2}}}|{} |{} |
6770
+ {11,12,23} |{{3,4},{4, 5}} |{"foobar"} |{{"elt1","elt2"}}|{"3.4","6.7"}
6771
+ {} |{3,4} |{"foo","bar"}|{"bar", "foo"} |
6772
6772
(3 rows)
6773
6773
6774
6774
QUERY: SELECT arrtest.a[1],
@@ -6780,8 +6780,8 @@ QUERY: SELECT arrtest.a[1],
6780
6780
a|b|c |d |e
6781
6781
--+-+------+----+-
6782
6782
1|0| | |
6783
- 11|3 |foobar|elt1|
6784
- |3 |foo |bar |
6783
+ 11| |foobar|elt1|
6784
+ | |foo | |
6785
6785
(3 rows)
6786
6786
6787
6787
QUERY: SELECT arrtest.a[1:3],
@@ -6791,17 +6791,17 @@ QUERY: SELECT arrtest.a[1:3],
6791
6791
FROM arrtest;
6792
6792
a |b |c |d
6793
6793
----------+---------------+-------------+-----------------
6794
- {1,2,3} | | |
6794
+ {1,2,3} |{{{0,0},{1,2}}} | |
6795
6795
{11,12,23}| | |{{"elt1","elt2"}}
6796
- |{{{3,4},{0,0}}} |{"foo","bar"}|
6796
+ | |{"foo","bar"}|
6797
6797
(3 rows)
6798
6798
6799
6799
QUERY: SELECT array_dims(arrtest.b) AS x;
6800
6800
x
6801
6801
---------------
6802
- [1:2][1:1][1:2]
6803
- [1:2][1:2][1:1]
6804
6802
[1:1][1:2][1:2]
6803
+ [1:2][1:2]
6804
+ [1:2]
6805
6805
(3 rows)
6806
6806
6807
6807
QUERY: SELECT *
@@ -6819,9 +6819,9 @@ QUERY: SELECT arrtest.a[1:3],
6819
6819
FROM arrtest;
6820
6820
a |b |c |d
6821
6821
----------+---------------+-------------+-----------------
6822
- {1,2,3} | | |
6822
+ {1,2,3} |{{{0,0},{1,2}}} | |
6823
6823
{11,12,23}| | |{{"elt1","elt2"}}
6824
- |{{{3,4},{0,0}}} |{"foo","bar"}|
6824
+ | |{"foo","bar"}|
6825
6825
(3 rows)
6826
6826
6827
6827
=============== running error queries ... =================
0 commit comments