Re: Nested-Internal Functions - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Nested-Internal Functions
Date
Msg-id CAFj8pRAHKym0FmNtCSRz=Ra2usJogUzJXRnzC6bNY61D_kttew@mail.gmail.com
Whole thread Raw
In response to AW: Nested-Internal Functions  ("Rossana Ocampos" <rocampos@bry-it.com>)
List pgsql-general
Hi

čt 18. 1. 2024 v 13:31 odesílatel Rossana Ocampos <rocampos@bry-it.com> napsal:
Effectively I had to create the function externally, I am in the process of migrating from Oracle to Postgresql and I have many cases of encapsulated functions and transactions.
Thank you very much for the return.
Rossana Ocampos

There is not any help or possibility - this Oracle's functionality is not supported ever. There is not any workaround.

Regards

Pavel


-----Ursprüngliche Nachricht-----
Von: Laurenz Albe [mailto:laurenz.albe@cybertec.at]
Gesendet: Dienstag, 16. Januar 2024 15:42
An: Rossana Ocampos; pgsql-general@lists.postgresql.org
Betreff: Re: Nested-Internal Functions

On Tue, 2024-01-16 at 13:15 +0100, Rossana Ocampos wrote:
> I have a query about creating nested functions in PostgreSQL.

There are no "nested functions" in PostgreSQL.
You'd need to rewrite that to use a proper stand-alone function.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: undefined symbol when installing pgcrypto on 16.1
Next
From: Ben Hancock
Date:
Subject: Obtaining printed copies of the PostgreSQL manual