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

From: e(dot)delanoe(at)gea(dot)fr
To: pgsql-bugs(at)postgresql(dot)org
Cc: e(dot)delanoe(at)gea(dot)fr
Subject: BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)
Date: 2017-09-18 08:24:35
Message-ID: 20170918082435.8886.46152@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14818
Logged by: Eric Delanoë
Email address: e(dot)delanoe(at)gea(dot)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 ?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-09-18 13:55:54 Re: BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)
Previous Message Tom Lane 2017-09-17 17:15:34 Re: Query planner skipping index depending on DISTINCT parameter order (2)