Can you describe what you mean by log statements? I have log_statement enabled and I can see the queries; the problem is the output is not logged and not what I expect. I need to modify the function so it shows the output of an intermediate CTE when I run it with specific inputs, and that's currently a little cumbersome.
-- Kevin Burke 925.271.7005 | kev.inburke.com On Tue, Dec 19, 2017 at 11:43 AM, Michael Nolan <htf...@gmail.com> wrote: > > > On Tue, Dec 19, 2017 at 1:24 PM, Kevin Burke <k...@inburke.com> wrote: > >> I'm writing a function that looks a little like this: >> >> >> This seems pretty cumbersome. Is there an easier way I am missing? >> Specifically it would be neat if it was easier to visualize the >> intermediate steps in the query production. If there are professional tools >> that help with this I would appreciate pointers to those as well. >> >> -- >> Kevin Burke >> 925.271.7005 <(925)%20271-7005> | kev.inburke.com >> > > Assuming it's not a function in production yet, put some log statements in > it, then check the logs. If it's already in production, you'll probably > have to create a separate version of the function for testing. > -- > Mike Nolan >
