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