Re: calling functions which take user defined types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: calling functions which take user defined types
Дата
Msg-id 19612.1282746648@sss.pgh.pa.us
обсуждение исходный текст
Ответ на calling functions which take user defined types  (Siddharth Saha <siddharthsaha@drishti-soft.com>)
Список pgsql-novice
Siddharth Saha <siddharthsaha@drishti-soft.com> writes:
> Can someone tell me how to invoke a UDF which takes a user-defined type as
> one of its arguments.

It's not significantly different from calling functions with built-in types.
Typically you'd do

    select myfunc('value', ...);

for a scalar type, or

    select myfunc(row('value', 'value', ...), ...);

for a composite type.

            regards, tom lane

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

Предыдущее
От: Siddharth Saha
Дата:
Сообщение: calling functions which take user defined types
Следующее
От: "Carel Combrink"
Дата:
Сообщение: Display XML Table output in Browser