From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: In plpgsql, allow %TYPE and %ROWTYPE to be followed by array dec
Date: Thu, 04 Jan 2024 20:24:21 +0000
Message-ID: <E1rLUGL-00DVla-80@gemulon.postgresql.org> (raw)
In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration.
This provides the useful ability to declare a variable that is an array
of the type of some other variable or some table column.
Quan Zongliang, Pavel Stehule
Discussion: https://postgr.es/m/ec4523e1-9e7e-f3ef-f9ce-bafd680ad6f6@yeah.net
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/5e8674dc83926f52516f847f1a77e8d38e94e143
Modified Files
--------------
doc/src/sgml/plpgsql.sgml | 29 ++++++++-
src/pl/plpgsql/src/expected/plpgsql_array.out | 79 ++++++++++++++++++++++++
src/pl/plpgsql/src/pl_comp.c | 27 +++++++++
src/pl/plpgsql/src/pl_gram.y | 86 ++++++++++++++++++---------
src/pl/plpgsql/src/plpgsql.h | 1 +
src/pl/plpgsql/src/sql/plpgsql_array.sql | 71 ++++++++++++++++++++++
6 files changed, 261 insertions(+), 32 deletions(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: In plpgsql, allow %TYPE and %ROWTYPE to be followed by array dec
In-Reply-To: <E1rLUGL-00DVla-80@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox