Re: Connection local variables?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Steve - DND <postgres(at)digitalnothing(dot)com>
Cc: postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connection local variables?
Date: 2005-06-29 07:02:23
Message-ID: 42C2477F.7050808@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve - DND wrote:
> Is there a way to create a variable specific to the current working
> connection? Like a connection context or some such? I'm trying to take a
> variable in a query, and allow it to be used by a rule.

You can create functions in a language that allows global storage.
Search in the archives for "app_session tcl" for examples of what I use.
http://archives.postgresql.org/

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zlatko Matic 2005-06-29 09:28:54 Re: automating backup ?
Previous Message Richard Huxton 2005-06-29 07:00:09 Re: Advice on merging two primary keys...