> david.g.johns...@gmail.com wrote: > >> 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. > »
Thanks for the quick reply, David. I looked at "43.5.1. Assignment" (https://www.postgresql.org/docs/14/plpgsql-statements.html#PLPGSQL-STATEMENTS-ASSIGNMENT). I searched in the page for « ]. » and found this: complex_array[n].realpart = 12.3; The corresponding page for Version 13 has no hits for « ]. ». So that seems to be a clear answer to my question.
