Обсуждение: refer function name by a variable in the function body
Hi All:
I use the function name in the body of pgsql code of the same function. Is the function name set to any variable that i can easily reference. Now I'm hard coding the function name in the code.
create or replace function compute_X(a1 text) returns text as
.....
...
Begin
.....
....
select user into user_id;
raise info 'starting function compute_X as %' user_id || timeofday();
end;
In the above Raise info i use select user to get the login role, similarly can i use a variable for function name which is automatically set by the system.
Thanks,
-SR
On Tue, Feb 16, 2016 at 09:41:18AM -0600, Suresh Raja wrote:
> I use the function name in the body of pgsql code of the same function. Is
> the function name set to any variable that i can easily reference. Now I'm
> hard coding the function name in the code.
> In the above Raise info i use select user to get the login role, similarly
> can i use a variable for function name which is automatically set by the
> system.
There is no such variable, unfortunately.
Also, please don't cross-post to multiple lists - replied only to
-general, as the question is not about sql language.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/