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
begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:[EMAIL PROTECTED]
tel;work:+49 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
