2 ms·
I think a big value add would be to have print-based debugging features for the functions (I'm not familiar with PostgreSQL custom functions so apologies if tha
by noisy_boy 5y ago
I think a big value add would be to have print-based debugging features for the functions (I'm not familiar with PostgreSQL custom functions so apologies if that already exists). E.g. a very common scenario while debugging a complicated query is to verify why the output is not as expected and that means repeatedly taking subparts of the query until we zero in on the problem. CTEs make it somewhat better but not ideal. If we have support for some sort of (conditional) print output (separate to the main output), it might help turning them on if/when needed (sort of like loglevels). Just thinking aloud - I'm sure there are lots of practical/conceptual roadblocks with it.