Re: Session variables (how do I pass session data to a function) - Mailing list pgsql-general

Philip W. Dalrymple wrote:
>
> What I want to do is to add to this another field that will be NULL
> UNLESS the session sets a value to the "user" for that the middle-wear
> system is acting for.

This can be done via a setting.  See
http://www.postgresql.org/docs/8.2/static/functions-admin.html#FUNCTIONS-ADMIN-SET-TABLE

If you'd like to read a fuller discussion of this very topic, search for
a thread titled "can I define own variables" in the archives.  I had to
do the same thing back then.

--
Guy Rouillier