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

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers\(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: EXPLAIN doesn't show the actual function expression for FunctionScan
Date: 2010-08-26 09:54:49
Message-ID: 877hjd66mu.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2010-08-26 09:56:23 Re: WIP: extensible enums
Previous Message Dimitri Fontaine 2010-08-26 09:53:36 Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)