Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f)

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f)
Дата
Msg-id
20170130234749.ellkbtdexhdoq7y5@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
[HACKERS] Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Rushabh Lathia <rushabh.lathia@gmail.com>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: Query fails when SRFs are part of FROM clause (Commit id:69f4b9c85f) Noah Misch <noah@leadboat.com>
Re: Re: Query fails when SRFs are part of FROM clause(Commit id: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: Re: Query fails when SRFs are part of FROM clause(Commit id: 69f4b9c85f) Noah Misch <noah@leadboat.com>
Re: Re: Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Re: Query fails when SRFs are part of FROM clause(Commit id: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: Query fails when SRFs are part of FROM clause(Commit id: 69f4b9c85f) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Re: Query fails when SRFs are part of FROM clause(Commit id: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Re: Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Re: Query fails when SRFs are part of FROM clause(Commit id: 69f4b9c85f) Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) "David G. Johnston" <david.g.johnston@gmail.com>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) Rushabh Lathia <rushabh.lathia@gmail.com>
Re: [HACKERS] Query fails when SRFs are part of FROM clause (Commitid: 69f4b9c85f) "David G. Johnston" <david.g.johnston@gmail.com>
On 2017-01-30 17:24:31 -0500, Tom Lane wrote:
> Make it work like Agg and WindowFunc.  To wit, dump the actually special
> function calls (the set-returning functions) into a list that's internal
> to the FunctionScan node, and then anything above those goes into scalar
> expressions in the node's tlist, which refer to the SRF outputs using
> Vars or things morally equivalent to Vars.

Hm. That should be fairly doable.  (I'd advocate very strongly against
building that list via ExecInitExpr, but that's an implementation
detail).  We'd evaluate SRFs early, but that's just consistent with
targetlist SRFs.

Wonder if we there's an argument to be made for implementing this
roughly similarly to split_pathtarget_at_srf - instead of injecting a
ProjectSet node we'd add a FunctionScan node below a Result node.

- Andres


В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] patch proposal
От: Peter Geoghegan
Дата:
FAQ