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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EXPLAIN doesn't show the actual function expression for FunctionScan
Дата
Msg-id 19397.1282745918@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: EXPLAIN doesn't show the actual function expression for FunctionScan  (Dimitri Fontaine <dfontaine@hi-media.com>)
Ответы Re: EXPLAIN doesn't show the actual function expression for FunctionScan  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-hackers
Dimitri Fontaine <dfontaine@hi-media.com> writes:
> Argument List?

Well, as shown in the example I posted, it's not just the argument list
but the whole call:

>> Function Call: unnest(ARRAY[ROW(('1.2.2'::text)::semver, '='::text, ('1.2.2'::text)::semver), ROW('1.2.23', '=',
'1.2.23')])

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.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Markus Wanner
Дата:
Сообщение: Re: Version Numbering
Следующее
От: Robert Haas
Дата:
Сообщение: Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)