From: miko@idocs.com
To: pgsql-sql@postgresql.org
Subject: Re: [BUGS] session variable
Date: 13 Sep 2003 11:23:36 -0700
Message-ID: <db27ea77.0309131023.4b94ae6@posting.google.com> (raw)
References: <Pine.LNX.4.44.0309031940040.1035-100000@peter.localdomain>
<200309032042.h83KgmJ24665@candle.pha.pa.us>
pgman@candle.pha.pa.us (Bruce Momjian) wrote in message news:<200309032042.h83KgmJ24665@candle.pha.pa.us>...
> Yes, see the FAQ. You have to use EXECUTE for temp table access in
> functions.
Unfortunately in the 7.2.x version I have available, EXECUTE does not
allow "select into". The docs suggests a technique for using a FOR
loop to extract information from an EXECUTE, but the technique only
works for finite set of expected variables, not for arbitrary values.
Any suggestions on how to kludge this issue? It would be of great
value to me if there were a way to set and retrieve just one global
variable that persists throughout a session, and which can be
retrieved from a function.
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: miko@idocs.com
Subject: Re: [BUGS] session variable
In-Reply-To: <db27ea77.0309131023.4b94ae6@posting.google.com>
* 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