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: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: /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.
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 |