I have written a function in PostgreSQL, but I get errors when I execute it. My function calls regex_split_to_array, but the error indicates that an array element is null. However, if I execute the regex_split_to_array in a select statement, I can see that all elements have a value.
I see that there is a debugger for SQL Server (https://www.devart.com/dbforge/sql/stud ... ugger.html). Is there such a thing for PostgreSQL? If not, how else can I debug my function?
How can I debug a PostgreSQL function in dbForge?
Re: How can I debug a PostgreSQL function in dbForge?
We are planning to implement this feature in the next version 2.2.