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/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
raise info 'starting function compute_X as %' user_id || timeofday();
Use 'user' or 'current_user' instead of user_id, it will work. You've typo,
comma is missing before user_id.
Regards,
Amul Sul
--
View this message in context: http://postgresql.nabble.com/refer-function-name-by-a-variable-in-the-function-body-tp5887848p5888012.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql