Horton

In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 5e8674dc83926f52516f847f1a77e8d38e94e143
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-01-04T20:24:15Z
Releases: 17.0 
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

Files

PathChange+/−
doc/src/sgml/plpgsql.sgml modified +26 −3
src/pl/plpgsql/src/expected/plpgsql_array.out modified +79 −0
src/pl/plpgsql/src/pl_comp.c modified +27 −0
src/pl/plpgsql/src/pl_gram.y modified +57 −29
src/pl/plpgsql/src/plpgsql.h modified +1 −0
src/pl/plpgsql/src/sql/plpgsql_array.sql modified +71 −0

Documentation touched

Discussion