Re: Nested Procedures

From: Amul Sul <sulamul(at)gmail(dot)com>
To: DAVID ROTH <adaptron(at)comcast(dot)net>
Cc: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: Nested Procedures
Date: 2021-07-20 03:43:03
Message-ID: CAAJ_b96eJaLnjY=SfVxyvvYnH8=Z49xLD4y6YqozSeAbZLDNYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)comcast(dot)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 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Matt Russo (mrusso) 2021-07-22 15:28:28 FW: PostgreSQL ODBC driver will not connect Thanks.
Previous Message DAVID ROTH 2021-07-19 18:20:36 Nested Procedures