Thread: NEW and a subselect in a rule

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.

>
> 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)?
>
Could we see the CREATE RULE command causing the error?
Regards, Christoph

On Thu, Jul 31, 2003 at 10:00:07AM +0200, Christoph Haller wrote:
> >
> > 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)?
> >
> Could we see the CREATE RULE command causing the error?

I've sent the other message (with the Subject: Nonexistent NEW
relation...) into the list.  The code is there.  The problem is
already closed (not solved!).  Thanks anyway.