Connection local variables?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Connection local variables?

Steve - DND
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.

Thanks,
Steve



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Reply | Threaded
Open this post in threaded view
|

Re: Connection local variables?

Richard Huxton
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster