Thread: refer function name by a variable in the function body

refer function name by a variable in the function body

From

Suresh Raja

Date:

16 February 2016, 18:41:23

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

Re: refer function name by a variable in the function body

From

amulsul

Date:

17 February 2016, 15:54:12

>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.