Re: delta relations in AFTER triggers - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: delta relations in AFTER triggers
Date
Msg-id 53FE0C9C.5000209@nasby.net
Whole thread Raw
In response to Re: delta relations in AFTER triggers  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: delta relations in AFTER triggers
Re: delta relations in AFTER triggers
List pgsql-hackers
On 8/27/14, 2:23 AM, Heikki Linnakangas wrote:
> Does this make sense? In essence, make the relations work like PL/pgSQL variables do. If you squint a little, the
new/oldrelation is a variable from the function's point of view, and a parameter from the planner/executor's point of
view.It's just a variable/parameter that holds a set of tuples, instead of a single Datum.
 

Something to keep in mind is that users will definitely think about NEW/OLD as tables. I suspect that it won't be long
afterrelease before someone asks why they can't create an index on it. :)
 
-- 
Jim C. Nasby, Data Architect                       jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Similar to csvlog but not really, json logs?
Next
From: Andres Freund
Date:
Subject: Re: Similar to csvlog but not really, json logs?