On 15 Oct. 2016 04:56, "Corey Huinker" <corey.huin...@gmail.com> wrote:

> I would like to make COPY itself a SRF. That's a bit beyond my
capabilities, so if that is the route we want to go, I will need help.
> The syntax would probably look like this (new bits in bold):
>> WITH my_copy  AS (
>>     COPY FROM 'example.csv' TO RESULT SET(c1 text, c2 integer, dummy1
text, dummy2 text, c5 date) WITH (FORMAT CSV)
>>     RETURNING c1, c2, c3
>> )

Strong -1 from me on this approach. Our CTE implementation materializes
everything so this is no better than COPYing to a temp table.

Not unless you plan to fix that (and figure out the backward compatibility
issues since the bug is documented as a feature) or implement RETURNING in
subqueries... I'd go for the function.

Reply via email to