From: | <mgould(at)isstrucksoftware(dot)net> |
---|---|
To: | "Jasen Betts" <jasen(at)xnet(dot)co(dot)nz>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: why no create variable |
Date: | 2012-03-18 12:26:32 |
Message-ID: | 20120318052632.c760ddbd7c0975bc4b045766db7d895c.c575a910fa.wbe@email16.secureserver.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
create table works but causes a lot of selects through out the program to get various settings when using CREATE Variable and have it global means that you can set these values once when doing your init routine and not have to continuously go back to the table in every stored procedure to get the same data over and over. In my case I almost 99% of the time set these values from table values and then use them in read only mode. These are things that are normally static. I also have a group of "flags" that get initialized to 0 and can get set to 1 to help determine actions to take in a stored procedure.
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.
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
-------- Original Message --------
Subject: Re: [GENERAL] why no create variable
From: Jasen Betts jasen(at)xnet(dot)co(dot)nz
Date: Sat, March 17, 2012 9:57 pm
To: pgsql-general(at)postgresql(dot)org
On 2012-03-08, mgould(at)isstrucksoftware(dot)net mgould(at)isstrucksoftware(dot)net wrote:
There seems to be CREATE everything in Postgres but it would be really
nice to have a CREATE VARIABLE which would allow us to create global
variables. I know there are other techniques but this would be the
easiest when doing a init routine when a user logs in to the
application.
create a table.
--
⚂⚃ 100% natural
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Angelico | 2012-03-18 12:55:05 | Re: why no create variable |
Previous Message | Alexander LAW | 2012-03-18 09:04:51 | Re: BUG #6510: A simple prompt is displayed using wrong charset |