diff options
Diffstat (limited to 'src/test/regress/expected/arrays.out')
| -rw-r--r-- | src/test/regress/expected/arrays.out | 31 |
1 files changed, 15 insertions, 16 deletions
diff --git a/src/test/regress/expected/arrays.out b/src/test/regress/expected/arrays.out index 6e82a7d0a6..8647eccf14 100644 --- a/src/test/regress/expected/arrays.out +++ b/src/test/regress/expected/arrays.out @@ -11,26 +11,25 @@ CREATE TABLE arrtest ( g varchar(5)[] ); -- --- only this array as a 0-based 'e', the others are 1-based. --- 'e' is also a large object. +-- only the 'e' array is 0-based, the others are 1-based. -- -INSERT INTO arrtest (a[5], b[2][1][2], c, d, f, g) +INSERT INTO arrtest (a[1:5], b[1:1][1:2][1:2], c, d, f, g) VALUES ('{1,2,3,4,5}', '{{{0,0},{1,2}}}', '{}', '{}', '{}', '{}'); UPDATE arrtest SET e[0] = '1.1'; UPDATE arrtest SET e[1] = '2.2'; INSERT INTO arrtest (f) VALUES ('{"too long"}'); ERROR: value too long for type character(5) -INSERT INTO arrtest (a, b[2][2][1], c, d, e, f, g) +INSERT INTO arrtest (a, b[1:2][1:2], c, d, e, f, g) VALUES ('{11,12,23}', '{{3,4},{4,5}}', '{"foobar"}', '{{"elt1", "elt2"}}', '{"3.4", "6.7"}', '{"abc","abcde"}', '{"abc","abcde"}'); -INSERT INTO arrtest (a, b[1][2][2], c, d[2][1]) +INSERT INTO arrtest (a, b[1:2], c, d[1:2]) VALUES ('{}', '{3,4}', '{foo,bar}', '{bar,foo}'); SELECT * FROM arrtest; a | b | c | d | e | f | g -------------+-----------------+-----------+---------------+-----------+-----------------+------------- - {1,2,3,4,5} | {{{0,0},{1,2}}} | {} | {} | | {} | {} + {1,2,3,4,5} | {{{0,0},{1,2}}} | {} | {} | {1.1,2.2} | {} | {} {11,12,23} | {{3,4},{4,5}} | {foobar} | {{elt1,elt2}} | {3.4,6.7} | {"abc ",abcde} | {abc,abcde} {} | {3,4} | {foo,bar} | {bar,foo} | | | (3 rows) @@ -41,20 +40,20 @@ SELECT arrtest.a[1], arrtest.d[1][1], arrtest.e[0] FROM arrtest; - a | b | c | d | e -----+---+--------+------+--- - 1 | 0 | | | - 11 | | foobar | elt1 | - | | foo | | + a | b | c | d | e +----+---+--------+------+----- + 1 | 0 | | | 1.1 + 11 | | foobar | elt1 | + | | foo | | (3 rows) SELECT a[1], b[1][1][1], c[1], d[1][1], e[0] FROM arrtest; - a | b | c | d | e -----+---+--------+------+--- - 1 | 0 | | | - 11 | | foobar | elt1 | - | | foo | | + a | b | c | d | e +----+---+--------+------+----- + 1 | 0 | | | 1.1 + 11 | | foobar | elt1 | + | | foo | | (3 rows) SELECT a[1:3], |