Re: Arguments to foreign tables? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Arguments to foreign tables?
Date
Msg-id 13981.1352217650@sss.pgh.pa.us
Whole thread Raw
In response to Re: Arguments to foreign tables?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> (On another thought: why do Foreign Scans get to avoid the
> materialization we hate with SRFs?)

[ shrug... ]  That works both ways.  If it would be convenient for an
FDW to return a tuplestore, which is hardly unlikely, it's out of luck;
it has to do the expansion itself.

The fact that nodeFunctionscan forces materialization is not by any
means a fundamental property.  It's just that nobody bothered to
implement two code paths there.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: MySQL search query is not executing in Postgres DB
Next
From: Jeff Davis
Date:
Subject: Re: Arguments to foreign tables?