From: Rossana Ocampos <rocampos@bry-it.com>
To: pgsql-general@lists.postgresql.org
Subject: AW: Nested-Internal Functions
Date: Thu, 18 Jan 2024 09:47:06 +0100
Message-ID: <010201da49ea$eac25470$c046fd50$@bry-it.com> (raw)
In-Reply-To: <b75366a46474147c091ccb09e93ef941aa679e26.camel@cybertec.at>
References: <00d201da4875$ba6c8aa0$2f459fe0$@bry-it.com>
<b75366a46474147c091ccb09e93ef941aa679e26.camel@cybertec.at>
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
-----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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: rocampos@bry-it.com
Subject: Re: Nested-Internal Functions
In-Reply-To: <010201da49ea$eac25470$c046fd50$@bry-it.com>
References: <00d201da4875$ba6c8aa0$2f459fe0$@bry-it.com> <b75366a46474147c091ccb09e93ef941aa679e26.camel@cybertec.at> <010201da49ea$eac25470$c046fd50$@bry-it.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox