From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Changed SRF in targetlist handling |
Date: | 2016-08-22 18:44:17 |
Message-ID: | 20160822184417.vpf2reouotfjp64j@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2016-08-17 17:41:28 -0700, Andres Freund wrote:
> Tom, do you think this is roughly going in the right direction? My plan
> here is to develop two patches, to come before this:
>
> a) Allow to avoid using a tuplestore for SRF_PERCALL SRFs in ROWS FROM -
> otherwise our performance would regress noticeably in some cases.
> b) Allow ROWS FROM() to return SETOF RECORD type SRFs as one column,
> instead of expanded. That's important to be able move SETOF RECORD
> returning functions in the targetlist into ROWS FROM, which otherwise
> requires an explicit column list.
I'm working on these. Atm ExecMakeTableFunctionResult() resides in
execQual.c - I'm inlining it into nodeFunctionscan.c now, because
there's no other callers, and having it separate seems to bring no
benefit.
Please speak soon up if you disagree.
Andres
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2016-08-22 18:49:32 | Re: Exporting more function in libpq |
Previous Message | Andres Freund | 2016-08-22 17:59:12 | Re: New SQL counter statistics view (pg_stat_sql) |