Subscript expressions do not have to evaluate to integers

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: sean(at)materialize(dot)io
Subject: Subscript expressions do not have to evaluate to integers
Date: 2020-07-22 02:59:18
Message-ID: 159538675800.624.7728794628229799531@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/sql-expressions.html
Description:

Section 4.2.3. Subscripts of the documentation states:

> Each subscript is itself an expression, which must yield an integer
value.

However, the following query works on Postgres 12.1

SELECT (ARRAY[1, 2, 3]::integer[])[1.5];

array
-------
2

I believe a more appropriate statement would acknowledge that at least some
values undergo an explicit-style conversion to an integer.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Jürgen Purtz 2020-07-22 08:33:22 Import an XML file
Previous Message PASCAL CROZET 2020-07-21 23:49:08 RE: Additional Chapter for Tutorial