Re: EXPLAIN doesn't show the actual function expression for FunctionScan - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: EXPLAIN doesn't show the actual function expression for FunctionScan
Date
Msg-id 877hjd66mu.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: EXPLAIN doesn't show the actual function expression for FunctionScan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Now you might suggest that the function itself is redundant with the
> information given in the FunctionScan node line and so we need only
> show the argument list.  Unfortunately there are cases where this fails;
> in particular, the named function could have been "inlined" by the
> planner, meaning that the actual expression could be just about anything
> at all.  So I think that trying to be cute is a bad idea and we should
> just print the nodetree as-is.

Oh. +1 then.

Regards,
-- 
dim


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)
Next
From: Andrew Dunstan
Date:
Subject: Re: WIP: extensible enums