On Mon, Jul 25, 2022 at 10:34 AM Bryn Llewellyn <b...@yugabyte.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.
