Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
doc: improve description of subscripting of arrays
authorBruce Momjian <bruce@momjian.us>
Mon, 31 Aug 2020 17:49:17 +0000 (13:49 -0400)
committerBruce Momjian <bruce@momjian.us>
Mon, 31 Aug 2020 17:49:17 +0000 (13:49 -0400)
It wasn't clear the non-integers are cast to integers for subscripting,
rather than throwing an error.

Reported-by: sean@materialize.io
Discussion: https://postgr.es/m/159538675800.624.7728794628229799531@wrigleys.postgresql.org

Backpatch-through: 9.5

doc/src/sgml/syntax.sgml

index b7fae363fb3dcf85837d75f4023093566187e4ae..e16721107d78ee458e50a44c5cfc4a2b9c57440a 100644 (file)
@@ -1383,7 +1383,7 @@ CREATE FUNCTION dept(text) RETURNS dept
 </synopsis>
     (Here, the brackets <literal>[ ]</literal> are meant to appear literally.)
     Each <replaceable>subscript</replaceable> is itself an expression,
-    which must yield an integer value.
+    which will be rounded to the nearest integer value.
    </para>
 
    <para>