BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)

Started by Nonameover 8 years ago2 messagesbugs

e.delanoe@gea.fr

over 8 years ago

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

Tom Lane

tgl@sss.pgh.pa.us

over 8 years ago

In reply to: Noname (#1)

Re: BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)

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