schema level variables

[Paramveer.Singh]

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?

thanks
paraM

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Shridhar Daithankar]

On Wednesday 15 Sep 2004 6:12 pm, Pa*************@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

---------------------------(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