| From: | Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
|---|---|
| To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, PostgreSQL-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Nested funtion |
| Date: | 2016-03-28 04:14:01 |
| Message-ID: | CAGuFTBW18T5OQ7miMsDFEDS+skPjQ55X2ppCXdmJBWD2SsSafQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2016-03-28 04:27:21 | Re: [HACKERS] Nested funtion |
| Previous Message | Boyan Botev | 2016-03-26 19:47:11 | Re: View deleted records in a table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2016-03-28 04:27:21 | Re: [HACKERS] Nested funtion |
| Previous Message | David G. Johnston | 2016-03-28 03:51:20 | Re: Draft release notes for next week's releases |