On Aug 2, 2006, at 12:47 , Joe Conway wrote:
> regression=# create rule r2 as on update to src do insert into log
> values(old.*, 'old'), (new.*, 'new');
> ERROR: VALUES must not contain OLD or NEW references
>
Would it make sense to add a HINT as well, recommending the UNION
construct Tom mentioned earlier?
On Aug 2, 2006, at 11:52 , Tom Lane wrote:
> create rule r2 as on update to src do
> insert into log select old.*, 'old' union all new.*, 'new';
>
> or just use two separate INSERT commands in the rule.
>
Or is the general case too, uh, general for a HINT?
Michael Glaesemann
grzm seespotcode net