Re: delta relations in AFTER triggers

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