Re: PL/pgSQL: « arr[j].a := v » works fine in PG Version 14.4, fails to compile in Version 11.2. Which version brought the fix?

On Mon, Jul 25, 2022 at 10:34 AM Bryn Llewellyn <bryn(at)yugabyte(dot)com> wrote:

> I copied my testcase at the end. It runs OK and produces the output that I
> expect using PG Version 14.4. But using Version 11.9 (and earlier 11
> sub-versions), it fails to compile with this error:
>
> *syntax error at or near "."*
> *lhs[j].a := rhs[j].a;*
> * ^*
> If I comment out the "Ideal approach" loop, then it runs fine in PG 11 and
> produces the same output as the "Ideal approach" does in PG 14,
>
> I looked at the Release Notes for each of Versions 14, 13, and 12:
>
>
From the change to this page I'd say v14:

https://www.postgresql.org/docs/14/plpgsql-statements.html

The release note for v14 say:

PL/PgSQL:
Improve PL/pgSQL's expression and assignment parsing (Tom Lane)
This change allows assignment to array slices and nested record fields.

David J.