Re: Is querying SPITupleTable with SQL possible?

On 02/10/2019 16:11, Tom Lane wrote:
> Tom Mercha <mercha_t(at)hotmail(dot)com> writes:
>> I am using PostgreSQL's SPI to execute a simple SQL query (SELECT * FROM
>> ...) via SPI_exec. As a a result, I get an SPITupleTable with the
>> results of my query.
>> Now that I have the SPITupleTable, I was wondering if it would be
>> possible to later query over it further in my SQL statements using SPI,
>> for example, something a bit similar to SPI_Exec ("Select * FROM
>> :mySPITupleTable", 0);
>
> It's possible you could use the "transition table" (aka
> EphemeralNamedRelation) infrastructure for this, though I'm not sure
> if it's really a close fit, or whether it's been built out enough to
> support this usage. From memory, it wants to work with tuplestores,
> which are a bit heavier-weight than SPITupleTables.
>
> regards, tom lane
>

Thanks for this feedback! The EphemeralNamedRelation seems that it could
be a good fit for what I'm looking for.

However, I'm not quite so sure how I can query over the
EphemeralNamedRelation using SQL? Could someone indicate where I can
find an example?

Regards
Tom