Re: [GENERAL] why no create variable

2012-03-18 Thread mgould
 text/html; charset="utf-8": Unrecognized 
inline: top.letterhead

Re: [GENERAL] why no create variable

2012-03-18 Thread Chris Angelico
On Sun, Mar 18, 2012 at 11:26 PM, mgo...@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 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] why no create variable

2012-03-17 Thread Jasen Betts
On 2012-03-08, mgo...@isstrucksoftware.net mgo...@isstrucksoftware.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] why no create variable

2012-03-08 Thread mgould
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.

Best Regards
 
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general