Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records (well defined) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)
Date
Msg-id 9975.1505742954@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records(well defined)  (e.delanoe@gea.fr)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: e.delanoe@gea.fr
Date:
Subject: [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records(well defined)
Next
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] BUG #14785: Logical replication does not work after addinga column. Bug?