pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Christian Rishoej <chrris@mail.dk>
To: pgsql-sql@postgresql.org
Subject: Rules and variables?
Date: 18 May 2002 01:39:04 +0200
Message-ID: <1021678745.15813.42.camel@penelope.dyndns.dk> (raw)


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






view thread (2+ messages)  latest in thread

Message-ID: <1021678745.15813.42.camel@penelope.dyndns.dk>
Permalink:  ../1021678745.15813.42.camel@penelope.dyndns.dk/
Also on:    postgresql.org/message-id/1021678745.15813.42.camel@penelope.dyndns.dk

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: chrris@mail.dk
  Subject: Re: Rules and variables?
  In-Reply-To: <1021678745.15813.42.camel@penelope.dyndns.dk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox