Re: [SQL] refer function name by a variable in the function body

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>
Subject: Re: [SQL] refer function name by a variable in the function body
Date: 2016-02-16 16:15:39
Message-ID: 20160216161539.GB5441@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2016-02-16 16:59:43 Re: Proper use of Groups and Users (Roles).
Previous Message Tom Lane 2016-02-16 15:54:44 Re: Suggest note in index documentation about long running transactions

Browse pgsql-sql by date

  From Date Subject
Next Message amulsul 2016-02-17 12:54:08 Re: refer function name by a variable in the function body
Previous Message Suresh Raja 2016-02-16 15:41:18 refer function name by a variable in the function body