Re: can I define own variables?

Guy Rouillier <guyr-ml1@burntmail.com> writes:
> Tom Lane wrote:
>> Another possibility, if you only need to store and retrieve values
>> and not do anything especially interesting with them, is to abuse
>> the "custom GUC variable" facility.

> I've had several occasions when a user-defined variable would have come
> in handy.  What is the scope of user_vars as you've defined them above?

They'd act like any other GUC variable.  The scope of a SET would be the
current connection, but there are other ways to set them with larger scope.

            regards, tom lane