Re: [HACKERS] Nested funtion

Hi

2016-03-28 6:14 GMT+02:00 Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>:

> Hi
>
> Is there any way to create nested function?
>

Some languages supports this feature, like plv8, but plpgsql doesn't
support it,

You have to use two function and some implementation of session variables.

Regards

Pavel

>
> 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
>
>
>
> Thanks
> Sridhar BN
>