Re: can I define own variables?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: can I define own variables?
Дата
Msg-id 10109.1192243797@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: can I define own variables?  (Guy Rouillier <guyr-ml1@burntmail.com>)
Ответы Re: can I define own variables?
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Guy Rouillier
Дата:
Сообщение: Re: can I define own variables?
Следующее
От: Ron Peterson
Дата:
Сообщение: Re: convert binary string to datum