Re: why no create variable

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: why no create variable
Date: 2012-03-18 12:55:05
Message-ID: CAPTjJmqf0Wdu1k8-J7yT_kKrRUSCQCxnLLWaUAzV5x-9jVRfGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 18, 2012 at 11:26 PM, <mgould(at)isstrucksoftware(dot)net> wrote:
>
> Getting the information from a table works.  I now have a sessionsettings table, but I'm making way to many calls to it because 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-03-18 14:02:56 Re: One more query
Previous Message mgould 2012-03-18 12:26:32 Re: why no create variable