diff options
Diffstat (limited to 'src/test/regress/expected/arrays.out')
| -rw-r--r-- | src/test/regress/expected/arrays.out | 28 |
1 files changed, 2 insertions, 26 deletions
diff --git a/src/test/regress/expected/arrays.out b/src/test/regress/expected/arrays.out index 617cf09a9a..c5f638bd46 100644 --- a/src/test/regress/expected/arrays.out +++ b/src/test/regress/expected/arrays.out @@ -178,19 +178,13 @@ SELECT ARRAY(select f2 from arrtest_f order by f2) AS "ARRAY"; (1 row) -- functions -SELECT singleton_array(42) AS "{42}"; - {42} ------- - {42} -(1 row) - -SELECT array_append(singleton_array(42), 6) AS "{42,6}"; +SELECT array_append(array[42], 6) AS "{42,6}"; {42,6} -------- {42,6} (1 row) -SELECT array_prepend(6, singleton_array(42)) AS "{6,42}"; +SELECT array_prepend(6, array[42]) AS "{6,42}"; {6,42} -------- {6,42} @@ -214,24 +208,6 @@ SELECT array_cat(ARRAY[[3,4],[5,6]], ARRAY[1,2]) AS "{{3,4},{5,6},{1,2}}"; {{3,4},{5,6},{1,2}} (1 row) -SELECT array_subscript(n, 2) AS "1.2" FROM arrtest2; - 1.2 ------ - 1.2 -(1 row) - -SELECT array_assign(n, 2, 9.99) AS "{1.1,9.99,1.3}" FROM arrtest2; - {1.1,9.99,1.3} ----------------- - {1.1,9.99,1.3} -(1 row) - -SELECT array_subscript(array_assign(n, 2, 9.99), 2) AS "9.99" FROM arrtest2; - 9.99 ------- - 9.99 -(1 row) - -- operators SELECT a FROM arrtest WHERE b = ARRAY[[[113,142],[1,147]]]; a |