On Wednesday 15 Sep 2004 6:12 pm, [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
