Re: Composite Type Argument Construction to a Function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Composite Type Argument Construction to a Function
Дата
Msg-id 182.1096475282@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Composite Type Argument Construction to a Function  (<tsarevich@gmail.com>)
Список pgsql-general
<tsarevich@gmail.com> writes:
> My question is - HOW do I construct the argument to
> my_function(my_type) so that the function recognises that I am passing
> into it composite data?

Sorry, don't think you're going to have much joy on that in 7.3.

In 8.0 you could do it with a ROW() constructor, but there's no such
thing in 7.3.  IIRC the only way to pass a row value as a function
argument in 7.3 is to select the row from a table, viz

    select my_function(t.*) from some_table t;

            regards, tom lane

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

Предыдущее
От: "Net Virtual Mailing Lists"
Дата:
Сообщение: Re: Postgres inherited table, some questions...
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: string is sometimes null ?