On 12/5/2004 12:48 PM, Jake Stride wrote:
Bruno Wolff III wrote:
On Sun, Dec 05, 2004 at 16:55:33 +0000,Would this be a postgresql session? If so how do I go about accessing it from a query/setting the value of it? I have looked at set authorization but I don't think this is where I should be looking!
Jake Stride <[EMAIL PROTECTED]> wrote:
Is there anyway to declare a constant that you can then use within a postgresql 'session', i am connecting from a PHP based application and trying to integrate another.
At the worst you should be able to use a table with a row for each session
that includes the value to be used for each session.
PostgreSQL does not have userland session variables. You would have to write some custom set/get functions in a procedural language that is capable of holding global data across function calls (like PL/Tcl).
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
