Re: [HACKERS] How to define global variable in postgresql

2011-08-22 Thread Jim Nasby 
On Aug 19, 2011, at 4:15 PM, Valentine Gogichashvili wrote:
  Hello. How can we define a global variable in postgresql?
 
 you can also use global structure in plpython for example:
 
 http://www.postgresql.org/docs/9.0/static/plpython-sharing.html

Same thing with plperl.

BTW, if you want something that's global but also transactional then you'll 
want to use a temp table.
--
Jim C. Nasby, Database Architect   j...@nasby.net
512.569.9461 (cell) http://jim.nasby.net



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

[HACKERS] How to define global variable in postgresql

2011-08-19 Thread EazonGuo 
Hello. How can we define a global variable in postgresql?

-- 
Best regards

Eazon

Re: [HACKERS] How to define global variable in postgresql

2011-08-19 Thread Christopher Browne 
On Fri, Aug 19, 2011 at 10:58 AM, EazonGuo eazon...@gmail.com wrote:
 Hello. How can we define a global variable in postgresql?

I believe CREATE TABLE is the usual mechanism to do this sort of thing.
-- 
When confronted by a difficult problem, solve it by reducing it to the
question, How would the Lone Ranger handle this?

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

Re: [HACKERS] How to define global variable in postgresql

2011-08-19 Thread Florian Weimer 
 Hello. How can we define a global variable in postgresql?

Do you mean session-private, but persistent across transactions?
Configuration parameters can be abused for this purpose.

-- 
Florian Weimerfwei...@bfk.de
BFK edv-consulting GmbH   http://www.bfk.de/
Kriegsstraße 100  tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99

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

Re: [HACKERS] How to define global variable in postgresql

2011-08-19 Thread Valentine Gogichashvili 
 Hello. How can we define a global variable in postgresql?

you can also use global structure in plpython for example:

http://www.postgresql.org/docs/9.0/static/plpython-sharing.html