Search Postgresql Archives

refer function name by a variable in the function body

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux