[age] branch master updated: Changed age_sqrt & age_floor volatility to IMMUTABLE (#411)

[jo...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

joshinnis pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/age.git


The following commit(s) were added to refs/heads/master by this push:
     new c64b517  Changed age_sqrt & age_floor volatility to IMMUTABLE (#411)
c64b517 is described below

commit c64b5172fd56d6f846ac3b1ec3287bf26b4f8319
Author: M.Imran Zaheer <62...@users.noreply.github.com>
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.0.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/age--1.1.0.sql b/age--1.1.0.sql
index de074d8..62df282 100644
--- a/age--1.1.0.sql
+++ b/age--1.1.0.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';