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 ab370c64388835274463b8c892350b52e06deda0
Author: M.Imran Zaheer <[email protected]>
AuthorDate: Tue Dec 27 22:18:11 2022 +0500

    Changed age_sqrt & age_floor volatility to IMMUTABLE (#411)
    
    * Changed volatility categories of functions from STABLE to IMMUTABLE
    * As their result depends upon their input arguments only
    * Both are guaranteed to return the same result given the same arguments 
forever
    * They fulfill the requirements to be IMMUTABLE functions
---
 age--1.1.1.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/age--1.1.1.sql b/age--1.1.1.sql
index 692e956..89617f6 100644
--- a/age--1.1.1.sql
+++ b/age--1.1.1.sql
@@ -3721,7 +3721,7 @@ AS 'MODULE_PATHNAME';
 CREATE FUNCTION ag_catalog.age_floor(variadic "any")
 RETURNS agtype
 LANGUAGE c
-STABLE
+IMMUTABLE
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';
 
@@ -3770,7 +3770,7 @@ AS 'MODULE_PATHNAME';
 CREATE FUNCTION ag_catalog.age_sqrt(variadic "any")
 RETURNS agtype
 LANGUAGE c
-STABLE
+IMMUTABLE
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';
 

Reply via email to