This is an automated email from the ASF dual-hosted git repository. jgemignani pushed a commit to branch PG12 in repository https://gitbox.apache.org/repos/asf/age.git
commit c7ef62e9f59c041c24989ce827c10d7fad2541c6 Author: fatima <[email protected]> AuthorDate: Tue Dec 27 22:23:56 2022 +0500 Changed volatility category of age_rtrim,age_ltrim,age_trim (#410) * changing function definations of age_rtrim,ltrim,trim from stable to immutable * Changed volatility category of functions age_ltrim, age_rtrim, age_trim from STABLE to IMMUTABLE Reasons: - These functions will not scan/lookup database - They simply take the input (String), applies operation on it and returns the result - They cannot modify database - They are guaranteed to return the same results given the same arguments forever --- age--1.1.1.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/age--1.1.1.sql b/age--1.1.1.sql index bf6b296..e01c64d 100644 --- a/age--1.1.1.sql +++ b/age--1.1.1.sql @@ -3575,7 +3575,7 @@ AS 'MODULE_PATHNAME'; CREATE FUNCTION ag_catalog.age_ltrim(variadic "any") RETURNS agtype LANGUAGE c -STABLE +IMMUTABLE RETURNS NULL ON NULL INPUT PARALLEL SAFE AS 'MODULE_PATHNAME'; @@ -3583,7 +3583,7 @@ AS 'MODULE_PATHNAME'; CREATE FUNCTION ag_catalog.age_rtrim(variadic "any") RETURNS agtype LANGUAGE c -STABLE +IMMUTABLE RETURNS NULL ON NULL INPUT PARALLEL SAFE AS 'MODULE_PATHNAME'; @@ -3591,7 +3591,7 @@ AS 'MODULE_PATHNAME'; CREATE FUNCTION ag_catalog.age_trim(variadic "any") RETURNS agtype LANGUAGE c -STABLE +IMMUTABLE RETURNS NULL ON NULL INPUT PARALLEL SAFE AS 'MODULE_PATHNAME';
