public inbox for [email protected]  

help / color / mirror / Atom feed

Nested Procedures
2+ messages / 2 participants
[nested] [flat]

* Nested Procedures
@ 2021-07-19 18:20 DAVID ROTH <[email protected]>
  2021-07-20 03:43 ` Re: Nested Procedures Amul Sul <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: DAVID ROTH @ 2021-07-19 18:20 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Nested Procedures
  2021-07-19 18:20 Nested Procedures DAVID ROTH <[email protected]>
@ 2021-07-20 03:43 ` Amul Sul <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Amul Sul @ 2021-07-20 03:43 UTC (permalink / raw)
  To: DAVID ROTH <[email protected]>; +Cc: [email protected] <[email protected]>

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 <[email protected]> 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2021-07-20 03:43 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-07-19 18:20 Nested Procedures DAVID ROTH <[email protected]>
2021-07-20 03:43 ` Amul Sul <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox