Re: schema level variables

On Wednesday 15 Sep 2004 6:12 pm, Paramveer(dot)Singh(at)trilogy(dot)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