Re: EXPLAIN doesn't show the actual function expression for FunctionScan

Excerpts from Tom Lane's message of mar ago 24 11:36:50 -0400 2010:
> Andres Freund <andres(at)anarazel(dot)de> writes:
> > On Tuesday 24 August 2010 16:40:30 Tom Lane wrote:
> >> So I got annoyed by $SUBJECT just now while chasing Wheeler's bug
> >> report. Seems like this would be a good thing to print. Should
> >> it appear always, or just with VERBOSE, or ???
>
> > I vote for only showing it with verbose
>
> That'd be fine with me. The lack of prior complaints suggests that
> most of the time people don't need it.

Yeah, and if the expression is large, it could get cumbersome (consider
crosstab functions which are often called with large gobs of text). On
the other hand, the same case makes it very useful to have the text for
further research on query behavior.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support