Re: schema level variables - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: schema level variables
Date
Msg-id 200409152021.48546.shridhar@frodo.hserus.net
Whole thread Raw
In response to schema level variables  (Paramveer.Singh@trilogy.com)
List pgsql-general
On Wednesday 15 Sep 2004 6:12 pm, Paramveer.Singh@trilogy.com wrote:
> Hi!
> I am trying to port an oracle app to postgres, an I don't know what to do
> with package scope variables.
> I was looking up some documentation and it seems (IMHO) that schemas would
> be a nice place to put the variables in(as they already have functions,
> operators and types).
> Is this feasible? Is the dev team interested in doing this at some point in
> the future?

Can you replace the package level variable name with a function? The function
would run a select against a table that stores name/value pair. Of course the
table has to be limited to the schema itself..

Would that be an acceptable work-around?

 Shridhar

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: OS X Mac pgAdmin equivalent?
Next
From: Robert Fitzpatrick
Date:
Subject: Updating another table using a trigger