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 5CAE1D1C4C8
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 28 Jul 2003 23:19:52 +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 24326-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 28 Jul 2003 20:18:54 -0300 (ADT)
Received: from ward.six (unknown [212.57.171.32])
	by svr1.postgresql.org (Postfix) with ESMTP id 58827D1C4C1
	for <pgsql-sql@postgresql.org>; Mon, 28 Jul 2003 20:19:46 -0300 (ADT)
Date: Tue, 29 Jul 2003 04:50:53 +0600
From: Denis Zaitsev <zzz@anda.ru>
To: pgsql-sql@postgresql.org
Subject: NEW and a subselect in a rule
Message-ID: <20030729045053.A983@natasha.ward.six>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/420
X-Sequence-Number: 14534

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.