Обсуждение: 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/