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 DA776D1B4F9 for ; Sat, 13 Sep 2003 18:38:50 +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 59352-08 for ; Sat, 13 Sep 2003 15:38:41 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 4E00DD1B4F1 for ; Sat, 13 Sep 2003 15:38:39 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h8DIccsl066571 for ; Sat, 13 Sep 2003 18:38:38 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h8DINn2e057671 for pgsql-sql@postgresql.org; Sat, 13 Sep 2003 18:23:49 GMT From: miko@idocs.com (Miko O'Sullivan) X-Newsgroups: comp.databases.postgresql.sql Subject: Re: [BUGS] session variable Date: 13 Sep 2003 11:23:36 -0700 Organization: http://groups.google.com/ Lines: 13 Message-ID: References: <200309032042.h83KgmJ24665@candle.pha.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/163 X-Sequence-Number: 15141 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.