Re: Query regarding functions of postgres

Whether the below two functions can be marked immutable or not

1. If a function has constant Raise notice inside it. Eg.

2. If a function has Raise notice but extracting current user inside notice, although its output purely depends on its input arguments eg.

select outer_function();
                                      outer_function                                       
-------------------------------------------------------------------------------------------
 OuterFunction() -> Current user is postgres | InnerFunction() -> Current user is postgres
Shouldn't it be "InnerFunction() -> Current user is alex" instead of postgres as alex called the security invoker function