From: | "Wu, Fei" <wufei(dot)fnst(at)cn(dot)fujitsu(dot)com> |
---|---|
To: | Tom Mercha <mercha_t(at)hotmail(dot)com> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: Is querying SPITupleTable with SQL possible? |
Date: | 2019-12-20 01:53:44 |
Message-ID: | 369f002f1f5f4abca40e8db9b86293a6@G08CNEXMBPEKD06.g08.fujitsu.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I have had see your discussion about node EphemeralNamedRelation with the Community.
Now, I want to use this node in SQL(for test), I have saw the manual but could not understand,
can you show me a example on how to use it in SQL?
Thanks a lot~
Regards, wu fei
-----Original Message-----
From: Tom Mercha [mailto:mercha_t(at)hotmail(dot)com]
Sent: 2019年10月3日 2:53
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: 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
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2019-12-20 02:11:50 | Re: Read Uncommitted |
Previous Message | Tomas Vondra | 2019-12-20 01:39:11 | Re: How is this possible "publication does not exist" |