X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 2EC35D1C513
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 31 Jul 2003 08:00:10 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 29840-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 31 Jul 2003 04:59:07 -0300 (ADT)
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by svr1.postgresql.org (Postfix) with SMTP id CAC5CD1C509
	for <pgsql-sql@postgresql.org>; Thu, 31 Jul 2003 05:00:07 -0300 (ADT)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Thu Jul 31 10:00:08 2003 +0200
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id KAA28811; Thu, 31 Jul 2003 10:00:07 +0200 (METDST)
Message-ID: <3F28CC86.B82994F3@rodos.fzk.de>
Date: Thu, 31 Jul 2003 10:00:07 +0200
From: Christoph Haller <ch@rodos.fzk.de>
X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org, zzz@anda.ru
Subject: Re: NEW and a subselect in a rule
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char 9C hex) in message
	header 'Received' Received: \234by rodos.fzk.de...            ^
X-Archive-Number: 200307/481
X-Sequence-Number: 14595

>
> 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