Hi 2016-03-28 6:14 GMT+02:00 Sridhar N Bamandlapally <sridhar....@gmail.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 >