Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQRYX-001IlQ-Um for pgsql-general@arkaria.postgresql.org; Thu, 18 Jan 2024 12:31:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rQRYW-002Ia7-Sj for pgsql-general@arkaria.postgresql.org; Thu, 18 Jan 2024 12:31:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQO3O-001OVA-9D for pgsql-general@lists.postgresql.org; Thu, 18 Jan 2024 08:47:14 +0000 Received: from lvps91-250-99-172.dedicated.hosteurope.de ([91.250.99.172]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQO3K-0027jF-Uw for pgsql-general@lists.postgresql.org; Thu, 18 Jan 2024 08:47:12 +0000 Received: from HAPPIX (bry-it.net [37.24.105.49]) by lvps91-250-99-172.dedicated.hosteurope.de (Postfix) with ESMTPSA id 06685FA92D for ; Thu, 18 Jan 2024 09:47:07 +0100 (CET) From: "Rossana Ocampos" To: References: <00d201da4875$ba6c8aa0$2f459fe0$@bry-it.com> In-Reply-To: Subject: AW: Nested-Internal Functions Date: Thu, 18 Jan 2024 09:47:06 +0100 Message-ID: <010201da49ea$eac25470$c046fd50$@bry-it.com> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQFIheatFXlfYT4cb2ii3qcUjmr8rgF0Kzk3sfcoi8A= Content-Language: de List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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=C3=BCngliche Nachricht----- Von: Laurenz Albe [mailto:laurenz.albe@cybertec.at]=20 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