Обсуждение: [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records(well defined)

The following bug has been logged on the website:

Bug reference:      14818
Logged by:          Eric Delanoë
Email address:      e.delanoe@gea.fr
PostgreSQL version: 9.6.0
Operating system:   Windows server 2012 R2-64b + Windows 7-64b client
Description:

Hello,

In a plpgsql function, I have defined this variable, an array of records
using implicit record type from myTable:   myTableDataList myTable[];   -- myTable has a column "myCol integer"
I cannot fill it explicitly using:   myTableDataList[1].myCol := 1;
I get this error:   syntax error at or near "."

Is this a bug ? A bug in this release ? A limitation ?


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

e.delanoe@gea.fr writes:
> In a plpgsql function, I have defined this variable, an array of records
> using implicit record type from myTable:
>     myTableDataList myTable[];
>     -- myTable has a column "myCol integer"
> I cannot fill it explicitly using:
>     myTableDataList[1].myCol := 1;
> I get this error:
>     syntax error at or near "."

> Is this a bug ? A bug in this release ? A limitation ?

Nope, that's never been supported.  Sorry.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs