On 10/2/19 2:53 PM, Tom Mercha wrote: > 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?
You could look in the documentation for CREATE TRIGGER in PG 10 or later, specifically the clauses like REFERENCING NEW TABLE AS foo. https://www.postgresql.org/docs/10/sql-createtrigger.html While the trigger function is executing, it can do SPI SQL queries exactly as if there is a table named 'foo' sitting there, but it only "exists" for that function and only until it returns. Regards, -Chap
