pgsql: In plpgsql, unify duplicate variables for record and row cases.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: In plpgsql, unify duplicate variables for record and row cases.
Дата
Msg-id E1eNLOk-0007RG-Uj@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
In plpgsql, unify duplicate variables for record and row cases.

plpgsql's function exec_move_row() handles assignment of a composite
source value to either a PLpgSQL_rec or PLpgSQL_row target variable.
Oddly, rather than taking a single target argument which it could do
run-time type detection on, it was coded to take two separate arguments
(only one of which is allowed to be non-NULL).  This choice had then
back-propagated into storing two separate target variables in various
plpgsql statement nodes, with lots of duplicative coding and awkward
interface logic to support that.  Simplify matters by folding those
pairs down to single variables, distinguishing the two cases only
where we must ... which turns out to be only in exec_move_row itself.
This is purely refactoring and should not change any behavior.

In passing, remove unused field PLpgSQL_stmt_open.returntype.

Discussion: https://postgr.es/m/11787.1512713374@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/dd759b96ea8fa41b48541dd321c07d9a947f8de9

Modified Files
--------------
src/pl/plpgsql/src/pl_comp.c  |   2 +-
src/pl/plpgsql/src/pl_exec.c  | 111 ++++++++++++++-----------------------
src/pl/plpgsql/src/pl_funcs.c |  39 ++++---------
src/pl/plpgsql/src/pl_gram.y  | 126 +++++++++++++++---------------------------
src/pl/plpgsql/src/plpgsql.h  |  22 +++-----
5 files changed, 106 insertions(+), 194 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: doc: Add advice about systemd RemoveIPC
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Fix mistake in comment