Re: Nested funtion

On Sun, Mar 27, 2016 at 9:14 PM, Sridhar N Bamandlapally <
sridhar(dot)bn1(at)gmail(dot)com> 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.
​
​