Re: schema level variables

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: schema level variables
Дата
Msg-id 200409152021.48546.shridhar@frodo.hserus.net
обсуждение исходный текст
Ответ на schema level variables  (Paramveer.Singh@trilogy.com)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: OS X Mac pgAdmin equivalent?
Следующее
От: Robert Fitzpatrick
Дата:
Сообщение: Updating another table using a trigger