Re: setting custom session variables?

Joe Conway wrote:
> Tom Lane wrote:
>
>> Raphael Bauduin <raphael(dot)bauduin(at)be(dot)easynet(dot)net> writes:
>>
>>> Can I set my own postgresql session variables?
>>
>>
>> Not in existing releases. There is a feature in 8.0 that you could
>> use (or misuse?) that way.
>>
>
> Also see myfunc_setvar(), myfunc_getvar, and myfunc_rmvar() in:
> http://www.joeconway.com/myfunc.tgz
> for an example of how you could make your own. There is an article that
> briefly describes these functions here:
> http://www.onlamp.com/pub/a/onlamp/2004/06/28/postgresql_extensions.html
>

I finally had the time to test it and it does exactly what I need.
That saves us a lot of work, just as tablefunc does.

Thanks a lot!

Raph

>
> HTH,
>
> Joe