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