Functions refering directly to table columns?

Поиск
Список
Период
Сортировка
От cluster
Тема Functions refering directly to table columns?
Дата
Msg-id f85umu$222o$1@news.hub.org
обсуждение исходный текст
Ответы Re: Functions refering directly to table columns?
Список pgsql-general
When using a function I need to parse each value as argument, e.g.
   myFunction(arg1, arg2, ..., arg999)

However, if I can guarantee that the function will only be used with a
certain table, can I then omit the arguments and letting the function
refer to the table columns directly?
In that way I could just write
   myFunction()
which is much easier. Furthermore, if I redefine which columns the
function should use, I would only have to modify ONE place, namely the
function definition. Not tons of queries.

How can I obtain this non-argument-requiring function feature?




В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: ssl connections to postgresql
Следующее
От: cluster
Дата:
Сообщение: Re: Functions refering directly to table columns?