Message-ID: <3F548FD0.5070600@pse-consulting.de>
Date: Tue, 02 Sep 2003 14:40:48 +0200
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624
MIME-Version: 1.0
To: sad <sad@bankir.ru>
Cc: pgsql-bugs@postgresql.org
Subject: Re: session variable
References: <200309011657.h81Gva817128@candle.pha.pa.us>
	<200309021629.26156.sad@bankir.ru>
In-Reply-To: <200309021629.26156.sad@bankir.ru>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

sad wrote:

>>>is it possible to define user variables in session ?
>>>If not then is it planned to implement ?
>>>or it is principially impossible in PosqtgreSQL
>>>      
>>>
>>psql has variables, but in general we don't support session varibles.
>>You could create a temp table and put a value in there easily.
>>    
>>
>
>that's ok, unless i need to access it in a trigger.
>
No problem to use  a temp table in a trigger (which is local to the 
session), I do so myself. Still, session variables would be nice, making 
coding a little bit more comfortable.

>
>where may i ask a programming and perfomance question?
>i think mailing such questions to "BUGS" is not a good idea. 
>
Just use the pgsql-sql and pgsql-performance mailing lists.


Regards,
Andreas