Re: [GENERAL] Constaints

2004-12-05 Thread Andrew - Supernews
On 2004-12-05, Jan Wieck <[EMAIL PROTECTED]> wrote: > 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). You can fake session variables

Re: [GENERAL] Constaints

2004-12-05 Thread Bruno Wolff III
On Sun, Dec 05, 2004 at 17:48:32 +, Jake Stride <[EMAIL PROTECTED]> wrote: > 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! At the sta

Re: [GENERAL] Constaints

2004-12-05 Thread Jan Wieck
On 12/5/2004 12:48 PM, Jake Stride wrote: Bruno Wolff III wrote: On Sun, Dec 05, 2004 at 16:55:33 +, 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

Re: [GENERAL] Constaints

2004-12-05 Thread Jake Stride
Bruno Wolff III wrote: On Sun, Dec 05, 2004 at 16:55:33 +, 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

Re: [GENERAL] Constaints

2004-12-05 Thread Bruno Wolff III
On Sun, Dec 05, 2004 at 16:55:33 +, 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. > > What I want to be able to do is setu

[GENERAL] Constaints

2004-12-05 Thread Jake Stride
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. What I want to be able to do is setup a rule on another table so that whenever a query is run on the table it appends another