pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (2+ messages)

Message-ID: <010201da49ea$eac25470$c046fd50$@bry-it.com>
Permalink:  ../010201da49ea$eac25470$c046fd50$@bry-it.com/
Also on:    postgresql.org/message-id/010201da49ea$eac25470$c046fd50$@bry-it.com

 · 

reply

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