diff options
Diffstat (limited to 'doc/src/sgml/array.sgml')
-rw-r--r-- | doc/src/sgml/array.sgml | 14 |
1 files changed, 6 insertions, 8 deletions
diff --git a/doc/src/sgml/array.sgml b/doc/src/sgml/array.sgml index c24646e43ca..9255144999d 100644 --- a/doc/src/sgml/array.sgml +++ b/doc/src/sgml/array.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.47 2005/11/17 22:14:50 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.48 2005/11/19 01:50:08 tgl Exp $ --> <sect1 id="arrays"> <title>Arrays</title> @@ -391,13 +391,11 @@ SELECT ARRAY[5,6] || ARRAY[[1,2],[3,4]]; </para> <para> - When a single element is pushed on to the beginning of a one-dimensional - array, the result is an array with a lower bound subscript equal to - the right-hand operand's lower bound subscript, minus one. When a single - element is pushed on to the end of a one-dimensional array, the result is - an array retaining the lower bound of the left-hand operand. For example: + When a single element is pushed on to either the beginning or end of a + one-dimensional array, the result is an array with the same lower bound + subscript as the array operand. For example: <programlisting> -SELECT array_dims(1 || ARRAY[2,3]); +SELECT array_dims(1 || '[0:1]={2,3}'::int[]); array_dims ------------ [0:2] @@ -441,7 +439,7 @@ SELECT array_dims(ARRAY[[1,2],[3,4]] || ARRAY[[5,6],[7,8],[9,0]]); SELECT array_dims(ARRAY[1,2] || ARRAY[[3,4],[5,6]]); array_dims ------------ - [0:2][1:2] + [1:3][1:2] (1 row) </programlisting> </para> |