Postgres Pro
Downloads
Home   >   mailing lists

Thread: Nested Procedures

Nested Procedures

From
DAVID ROTH
Date:
Can I nest the definition of a procedure inside on another definition?
I am used to doing this in Oracle PL/SQL where a local procedure can be defined inside the declaration section of another procedure.
 
I am looking for 2 things as part of a migration effort.
1) Best way to replace Oracle packages.
2) Best way to define "private" procedures and functions.
 
Thanks
Dave R

Re: Nested Procedures

From
Amul Sul
Date:
PostgreSQL doesn't have those options, but EDB Postgres Advanced
Server does provide that.

Regards,
Amul

On Mon, Jul 19, 2021 at 11:50 PM DAVID ROTH <adaptron@comcast.net> wrote:
>
> Can I nest the definition of a procedure inside on another definition?
> I am used to doing this in Oracle PL/SQL where a local procedure can be defined inside the declaration section of
anotherprocedure.
 
>
> I am looking for 2 things as part of a migration effort.
> 1) Best way to replace Oracle packages.
> 2) Best way to define "private" procedures and functions.
>
> Thanks
> Dave R