Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 0EFE0475F1A
	for <pgsql-sql@postgresql.org>; Fri, 17 May 2002 19:43:40 -0400 (EDT)
Received: from fepB.post.tele.dk (fepB.post.tele.dk [195.41.46.145])
	by postgresql.org (Postfix) with ESMTP id 54621475B46
	for <pgsql-sql@postgresql.org>; Fri, 17 May 2002 19:38:57 -0400 (EDT)
Received: from localhost.localdomain ([80.196.138.103]) by fepB.post.tele.dk
	(InterMail vM.4.01.03.23 201-229-121-123-20010418) with ESMTP
	id <20020517233858.GHHT6464.fepB.post.tele.dk@localhost.localdomain>
	for <pgsql-sql@postgresql.org>; Sat, 18 May 2002 01:38:58 +0200
Subject: Rules and variables?
From: Christian Rishoej <chrris@mail.dk>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.5 
Date: 18 May 2002 01:39:04 +0200
Message-Id: <1021678745.15813.42.camel@penelope.dyndns.dk>
Mime-Version: 1.0
X-Archive-Number: 200205/188
X-Sequence-Number: 7823


Hi,

I need to hold an integer value and use it in some queries in a rule I
have. I tried to use a temporary table, but without luck (got an error
like    Relation "tmpfoo" does not exist   ).

My question is: How can I hold this value thoughout the rule? Can I use
variables of some sort?

Christian