Re: SQL-standard function body
От
Tom Lane
Тема
Re: SQL-standard function body
Дата
Msg-id
982443.1623093873@sss.pgh.pa.us
Ответ на
Re: SQL-standard function body (Tom Lane)
Список
Дерево обсуждения
SQL-standard function body Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: SQL-standard function body Michael Paquier <michael@paquier.xyz>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: SQL-standard function body Georgios Kokolatos <gkokolatos@protonmail.com>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: SQL-standard function body Andres Freund <andres@anarazel.de>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Thomas Munro <thomas.munro@gmail.com>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Robert Haas <robertmhaas@gmail.com>
Re: SQL-standard function body Stephen Frost <sfrost@snowman.net>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Noah Misch <noah@leadboat.com>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Justin Pryzby <pryzby@telsasoft.com>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Noah Misch <noah@leadboat.com>
Re: SQL-standard function body Robert Haas <robertmhaas@gmail.com>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Bruce Momjian <bruce@momjian.us>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Pavel Stehule <pavel.stehule@gmail.com>
Re: SQL-standard function body Vik Fearing <vik@postgresfriends.org>
Re: SQL-standard function body Pavel Stehule <pavel.stehule@gmail.com>
Re: SQL-standard function body Vik Fearing <vik@postgresfriends.org>
Re: SQL-standard function body Pavel Stehule <pavel.stehule@gmail.com>
Re: SQL-standard function body Vik Fearing <vik@postgresfriends.org>
Re: SQL-standard function body Pavel Stehule <pavel.stehule@gmail.com>
Re: SQL-standard function body Pavel Stehule <pavel.stehule@gmail.com>
Re: SQL-standard function body Pavel Stehule <pavel.stehule@gmail.com>
Re: SQL-standard function body Thomas Munro <thomas.munro@gmail.com>
Re: SQL-standard function body Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL-standard function body Pavel Stehule <pavel.stehule@gmail.com>
I wrote:
> ... I tend to agree with Julien's position here. It seems really ugly
> to prohibit empty statements just for implementation convenience.
> However, the way I'd handle it is to have the grammar remove them,
> which is what it does in other contexts.
Concretely, I think the right fix is per attached.
Like Julien, I don't see any additional change in regression test outputs.
Maybe Peter thinks there should be some? But I think the reverse-listing
we get for functest_S_3a is fine.
regards, tom lane
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y
index 9ee90e3f13..52a254928f 100644
--- a/src/backend/parser/gram.y
+++ b/src/backend/parser/gram.y
@@ -7990,7 +7990,11 @@ opt_routine_body:
routine_body_stmt_list:
routine_body_stmt_list routine_body_stmt ';'
{
- $$ = lappend($1, $2);
+ /* As in stmtmulti, discard empty statements */
+ if ($2 != NULL)
+ $$ = lappend($1, $2);
+ else
+ $$ = $1;
}
| /*EMPTY*/
{
diff --git a/src/test/regress/expected/create_function_3.out b/src/test/regress/expected/create_function_3.out
index 5b6bc5eddb..5955859bb5 100644
--- a/src/test/regress/expected/create_function_3.out
+++ b/src/test/regress/expected/create_function_3.out
@@ -267,7 +267,7 @@ CREATE FUNCTION functest_S_3() RETURNS boolean
RETURN false;
CREATE FUNCTION functest_S_3a() RETURNS boolean
BEGIN ATOMIC
- RETURN false;
+ ;;RETURN false;;
END;
CREATE FUNCTION functest_S_10(a text, b date) RETURNS boolean
LANGUAGE SQL
diff --git a/src/test/regress/sql/create_function_3.sql b/src/test/regress/sql/create_function_3.sql
index 4b778999ed..6e8b838ff2 100644
--- a/src/test/regress/sql/create_function_3.sql
+++ b/src/test/regress/sql/create_function_3.sql
@@ -165,7 +165,7 @@ CREATE FUNCTION functest_S_3() RETURNS boolean
RETURN false;
CREATE FUNCTION functest_S_3a() RETURNS boolean
BEGIN ATOMIC
- RETURN false;
+ ;;RETURN false;;
END;
CREATE FUNCTION functest_S_10(a text, b date) RETURNS boolean
В списке pgsql-hackers по дате отправления