agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: hubert depesz lubaczewski <depesz@depesz.com>
To: pgsql-general@postgresql.org
Cc: Suresh Raja <suresh.rajaabc@gmail.com>
Subject: Re: [SQL] refer function name by a variable in the function body
Date: Tue, 16 Feb 2016 17:15:39 +0100
Message-ID: <20160216161539.GB5441@depesz.com> (raw)
In-Reply-To: <CAJP7dtDr++ZXgPEXoayNQfjjHBwBc7607iuj84PS2Pk8HZqfyQ@mail.gmail.com>
References: <CAJP7dtDr++ZXgPEXoayNQfjjHBwBc7607iuj84PS2Pk8HZqfyQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>

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

view thread (3+ messages)  latest in thread

Message-ID: <20160216161539.GB5441@depesz.com>
Permalink:  ../20160216161539.GB5441@depesz.com/
Also on:    postgresql.org/message-id/20160216161539.GB5441@depesz.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: depesz@depesz.com, pgsql-general@postgresql.org, suresh.rajaabc@gmail.com
  Subject: Re: [SQL] refer function name by a variable in the function body
  In-Reply-To: <20160216161539.GB5441@depesz.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox