diff options
Diffstat (limited to 'src/test/regress/expected/arrays.out')
| -rw-r--r-- | src/test/regress/expected/arrays.out | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/src/test/regress/expected/arrays.out b/src/test/regress/expected/arrays.out index ee08082d5b..219ac02629 100644 --- a/src/test/regress/expected/arrays.out +++ b/src/test/regress/expected/arrays.out @@ -190,10 +190,10 @@ SELECT array_prepend(6, array[42]) AS "{6,42}"; {6,42} (1 row) -SELECT array_cat(ARRAY[1,2], ARRAY[3,4]) AS "{{1,2},{3,4}}"; - {{1,2},{3,4}} ---------------- - {{1,2},{3,4}} +SELECT array_cat(ARRAY[1,2], ARRAY[3,4]) AS "{1,2,3,4}"; + {1,2,3,4} +----------- + {1,2,3,4} (1 row) SELECT array_cat(ARRAY[1,2], ARRAY[[3,4],[5,6]]) AS "{{1,2},{3,4},{5,6}}"; @@ -233,16 +233,16 @@ SELECT 0 || ARRAY[1,2] AS "{0,1,2}"; {0,1,2} (1 row) -SELECT ARRAY[1,2] || ARRAY[3,4] AS "{{1,2},{3,4}}"; - {{1,2},{3,4}} ---------------- - {{1,2},{3,4}} +SELECT ARRAY[1,2] || ARRAY[3,4] AS "{1,2,3,4}"; + {1,2,3,4} +----------- + {1,2,3,4} (1 row) SELECT ARRAY[[['hello','world']]] || ARRAY[[['happy','birthday']]] AS "ARRAY"; - ARRAY ------------------------------------------- - {{{{hello,world}}},{{{happy,birthday}}}} + ARRAY +-------------------------------------- + {{{hello,world}},{{happy,birthday}}} (1 row) SELECT ARRAY[[1,2],[3,4]] || ARRAY[5,6] AS "{{1,2},{3,4},{5,6}}"; @@ -251,10 +251,10 @@ SELECT ARRAY[[1,2],[3,4]] || ARRAY[5,6] AS "{{1,2},{3,4},{5,6}}"; {{1,2},{3,4},{5,6}} (1 row) -SELECT ARRAY[0,0] || ARRAY[1,1] || ARRAY[2,2] AS "{{0,0},{1,1},{2,2}}"; - {{0,0},{1,1},{2,2}} ---------------------- - {{0,0},{1,1},{2,2}} +SELECT ARRAY[0,0] || ARRAY[1,1] || ARRAY[2,2] AS "{0,0,1,1,2,2}"; + {0,0,1,1,2,2} +--------------- + {0,0,1,1,2,2} (1 row) SELECT 0 || ARRAY[1,2] || 3 AS "{0,1,2,3}"; |