[GENERAL] Custom Class variables

2009-07-14 Thread Michael Gould 
I have created the following in my postgres.conf file

custom_variable_classes = 'iss'

In a SQL session I've tried 

Set iss.one = '1'
set iss.two = '2'

Select * from iss;

How do I access the values from the custom class in sql code?

Best Regards

Michael Gould
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax



-- 
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] Custom Class variables

2009-07-14 Thread Alvaro Herrera 
Michael Gould wrote:
 I have created the following in my postgres.conf file
 
 custom_variable_classes = 'iss'
 
 In a SQL session I've tried 
 
 Set iss.one = '1'
 set iss.two = '2'
 
 Select * from iss;
 
 How do I access the values from the custom class in sql code?

show iss.one;
select current_setting('iss.one');

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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