pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedAw: Nested-Internal Functions
2+ messages / 2 participants
[nested] [flat]
* Aw: Nested-Internal Functions
@ 2024-01-16 12:53 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
1 sibling, 0 replies; 2+ messages in thread
From: Karsten Hilbert @ 2024-01-16 12:53 UTC (permalink / raw)
To: Rossana Ocampos <rocampos@bry-it.com>; +Cc: pgsql-general@lists.postgresql.org
> I am currently using PostgreSQL 15 and I am trying to create a nested function with the following structure:
...
> However, I get an error
What *is* the error ?
Karsten
^ permalink raw reply [nested|flat] 2+ messages in thread
* AW: Nested-Internal Functions
@ 2024-01-18 08:47 ` Rossana Ocampos <rocampos@bry-it.com>
1 sibling, 0 replies; 2+ messages in thread
From: Rossana Ocampos @ 2024-01-18 08:47 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-01-18 08:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-16 12:53 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
2024-01-18 08:47 ` AW: Nested-Internal Functions Rossana Ocampos <rocampos@bry-it.com>
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