Re: [HACKERS] Nested funtion

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Sun, Mar 27, 2016 at 9:14 PM, Sridhar N Bamandlapally <sridhar.bn1@xxxxxxxxx> wrote:

Hi

Is there any way to create nested function?

oracle to postgres migration required super function variable reference into nested function without nested function parameter

Oracle sample:

-------------------------------

create or replace function f1(n number) return number

is

    vs number:=1;

    function nf1(m number) return number is

    begin

        return vs + m + n;

    end;

begin

    return nf1(2);

end;

/

run:

--------

SQL> select f1(9) from dual;

     F1(9)

----------

        12

PostgreSQL's ​pl/pgsql langauge doesn't grok closures.  You are welcome to write "f1" in a language that does.  Perl and Python are built-in and many others are available.  I assume at least one of them can do this.

​David J.

​

​