Thread: [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records(well defined)
[BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records(well defined)
From
e.delanoe@gea.fr
Date:
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
Re: [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)
From
Tom Lane
Date:
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