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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: e(dot)delanoe(at)gea(dot)fr
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)
Date: 2017-09-18 13:55:54
Message-ID: 9975.1505742954@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

e(dot)delanoe(at)gea(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2017-09-18 14:23:47 Re: BUG #14785: Logical replication does not work after adding a column. Bug?
Previous Message e.delanoe 2017-09-18 08:24:35 BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)