Re: why no create variable

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Re: why no create variable
Дата
Msg-id CAPTjJmqf0Wdu1k8-J7yT_kKrRUSCQCxnLLWaUAzV5x-9jVRfGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: why no create variable  (<mgould@isstrucksoftware.net>)
Список pgsql-general
On Sun, Mar 18, 2012 at 11:26 PM, <mgould@isstrucksoftware.net> wrote:
>
> Getting the information from a table works.  I now have a sessionsettings table, but I'm making way to many calls to
itbecause there is no global pool of variable.  Not IMO an efficient use of a table. 

Chances are that table, if you are indeed using it a lot, will be
cached. It'll end up fairly cheap. But just out of vague curiosity, I
wonder how viable it would be to create functions for all your global
variables - each one is thus a function returning its value.

ChrisA

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

Предыдущее
От:
Дата:
Сообщение: Re: why no create variable
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: One more query