CURRENTE_DATE

2024-10-23 Thread Rossana Ocampos
Hello , I am new with PostgreSQL and I have a bug. I have created a function that has an input variable of type date , in case it does not receive value , it has to assume by default the current date. I have defined it as follows variable DATE DEFAULT CURRENT_DATE, but I get the following error.

AW: Nested-Internal Functions

2024-01-18 Thread Rossana Ocampos
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

Nested-Internal Functions

2024-01-16 Thread Rossana Ocampos
27;t compile the function. Thank you very much for your help Rossana Ocampos