Postgres Pro
Downloads
Home   >   mailing lists

Nested funtion - Mailing list pgsql-hackers

From Sridhar N Bamandlapally
Subject Nested funtion
Date
Msg-id CAGuFTBW18T5OQ7miMsDFEDS+skPjQ55X2ppCXdmJBWD2SsSafQ@mail.gmail.com
Whole thread Raw
Responses Re: Nested funtion  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Nested funtion  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view
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



Thanks
Sridhar BN

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Draft release notes for next week's releases
Next
From: Pavel Stehule
Date:
Subject: Re: Nested funtion