[SQL] NEW and a subselect in a rule

[Denis Zaitsev]

So, I met such a problem: it's impossible to use NEW in a subselect
used in a (non-select) rule.  The error is: <Relation "*NEW*" does not
exist>.  Is this a way to do that newertheless (without using of a
function, of course)?

Thanks in advance.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match