Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] refer function name by a variable in the function body - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: [SQL] refer function name by a variable in the function body
Date
Msg-id 20160216161539.GB5441@depesz.com
Whole thread Raw
In response to refer function name by a variable in the function body  (Suresh Raja <suresh.rajaabc@gmail.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Suggest note in index documentation about long running transactions
Next
From: Vincent Veyron
Date:
Subject: Re: Proper use of Groups and Users (Roles).