Re: function_name.parameter_name

Sergey Konoplev wrote:
> Hi,
> 
> On 7 September 2010 20:35, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > How does $subject differ from what we already do? ?See
> > http://www.postgresql.org/docs/9.0/static/plpgsql-structure.html
> 
> So will it be possible to do things like this?
> 
> 1.
> CREATE FUNCTION func_name(arg_name text) RETURNS integer AS $$
> BEGIN
>     RAISE INFO '%', func_name.arg_name;
> ...
> 
> 2.
> CREATE FUNCTION func_name() RETURNS integer AS $$
> DECLARE
>     var_name text := 'bla';
> BEGIN
>     RAISE INFO '%', func_name.var_name;
> ...
> 
> 3.
> CREATE FUNCTION func_very_very_very_very_long_name() RETURNS integer AS $$
> << func_alias >>
> DECLARE
>     var_name text := 'bla';
> BEGIN
>     RAISE INFO '%', func_alias.var_name;
> ...

In my testing #1 works, but #2 does not:
-- #1test=> CREATE OR REPLACE FUNCTION xxx(yyy INTEGER) RETURNS void AS $$BEGIN    xxx.yyy := 4;END;$$LANGUAGE
plpgsql;CREATEFUNCTION-- #2test=> CREATE OR REPLACE FUNCTION xxx() RETURNS void AS $$DECLARE yyy integer;BEGINxxx.yyy
:=4;END;$$LANGUAGE plpgsql;ERROR:  "xxx.yyy" is not a known variableLINE 3: xxx.yyy := 4;        ^
 

#2 works only if you specify a label above the DECLARE section and use
that label (not the function name) as a variable qualifier:
test=> CREATE OR REPLACE FUNCTION xxx() RETURNS void AS $$<<zzz>>DECLARE yyy INTEGER;BEGIN    zzz.yyy :=
4;END;$$LANGUAGEplpgsql;CREATE FUNCTION
 

Interestingly, I can use a label that matches the function name:
test=> CREATE OR REPLACE FUNCTION xxx() RETURNS void AS $$<<xxx>>DECLARE yyy INTEGER;BEGIN    xxx.yyy :=
4;END;$$LANGUAGEplpgsql;CREATE FUNCTION
 

but if you supply parameters to the function, it does not work:
test=> CREATE OR REPLACE FUNCTION xxx(aaa INTEGER) RETURNS void AS $$<<xxx>>DECLARE yyy INTEGER;BEGIN     xxx.yyy :=
4;END;$$LANGUAGEplpgsql;ERROR:  cannot change name of input parameter "yyy"HINT:  Use DROP FUNCTION first.
 

so this is not something we can recommend to users.

Note the text Tom quoted from our docs:
     http://www.postgresql.org/docs/9.0/static/plpgsql-structure.html
     There is actually a hidden <quote>outer block</> surrounding     the body of any <application>PL/pgSQL</>
function. This block     provides the declarations of the function's parameters (if any),     as well as some special
variablessuch as <literal>FOUND</literal>     (see <xref linkend="plpgsql-statements-diagnostics">).  The     outer
blockis labeled with the function's name, meaning that     parameters and special variables can be qualified with the
 function's name.
 

This talks about the parameters, but not about the DECLARE block.

The idea of adding a label to DECLARE blocks is mentioned in our docs:
http://www.postgresql.org/docs/9.0/static/plpgsql-implementation.html#PLPGSQL-VAR-SUBST
Alternatively you can qualify ambiguous references to make them clear.In the above example, src.foo  would be an
unambiguousreference to thetable column. To create an unambiguous reference to a variable, declareit in a labeled block
anduse the block's label (see Section 39.2).
 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +