[age] branch master updated: Update age_log10, age_e, age_exp VOLATILITY Classes (#427)

[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 bc3e287  Update age_log10, age_e, age_exp  VOLATILITY Classes (#427)
bc3e287 is described below

commit bc3e2875b487fadd0eecf857d26b2871f5b08f34
Author: moeed-k <99...@users.noreply.github.com>
AuthorDate: Wed Dec 28 19:35:23 2022 +0500

    Update age_log10, age_e, age_exp  VOLATILITY Classes (#427)
    
    -age_log10, age_e,age_exp function VOLATILITY changed from STABLE to IMMUTABLE
    -No database lookup or external configuration required for these functions
    -IMMUTABLE class allows the optimizer to build an index for faster processing
---
 age--1.1.0.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/age--1.1.0.sql b/age--1.1.0.sql
index b21b7d2..0e331fa 100644
--- a/age--1.1.0.sql
+++ b/age--1.1.0.sql
@@ -3749,21 +3749,21 @@ AS 'MODULE_PATHNAME';
 CREATE FUNCTION ag_catalog.age_log10(variadic "any")
 RETURNS agtype
 LANGUAGE c
-STABLE
+IMMUTABLE
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';
 
 CREATE FUNCTION ag_catalog.age_e()
 RETURNS agtype
 LANGUAGE c
-STABLE
+IMMUTABLE
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';
 
 CREATE FUNCTION ag_catalog.age_exp(variadic "any")
 RETURNS agtype
 LANGUAGE c
-STABLE
+IMMUTABLE
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';