Re: [BUGS] session variable - Mailing list pgsql-sql

From miko@idocs.com (Miko O'Sullivan)
Subject Re: [BUGS] session variable
Date
Msg-id db27ea77.0309131023.4b94ae6@posting.google.com
Whole thread Raw
In response to Re: [BUGS] session variable  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: [BUGS] session variable  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: David W Noon
Date:
Subject: Re: how to get decimal to date form
Next
From: Kyle
Date:
Subject: Trigger on view