Re: Debugging a function - what's the best way to do this quickly?

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 <htfoot(at)gmail(dot)com> wrote:

>
>
> On Tue, Dec 19, 2017 at 1:24 PM, Kevin Burke <kev(at)inburke(dot)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
>