Re: howto set a variable in transaction context

thanks, it works

A. Kretschmer schrieb:
> am  Thu, dem 10.04.2008, um 13:32:04 +0200 mailte Thomas Markus folgendes:
>
>> hi list,
>>
>> how can i set a variable, which content is only visible in current
>> transaction?
>> i know the way to create a temp table with
>>
>> create temp table ... on commit drop
>>
>> but i dont like that way. something like
>> |
>> set_config(setting_name, new_value, is_local)
>>
>> is it possible?
>>
>
> Yes, you can use this:
> http://www.postgresql.org/docs/current/interactive/runtime-config-custom.html
>
>
> How to use?
>
http://groups.google.de/group/pgsql.general/browse_thread/thread/f914569b73d17258/5c0cb606d0ce698d?lnk=st&q=#5c0cb606d0ce698d
>
>
> HTH, Andreas
>