Re: function SETOF return type with variable columns?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: function SETOF return type with variable columns?
Дата
Msg-id 11298.1219284514@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: function SETOF return type with variable columns?  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы Re: function SETOF return type with variable columns?
Список pgsql-general
"Merlin Moncure" <mmoncure@gmail.com> writes:
> PostgreSQL functions are for the most part strictly bound to their
> return type.

There is, however, the trick of declaring the function as "returns
record" and then specifying the names and types of the output columns
in the calling query.  I'm not sure how practical that is to use with
a plpgsql function, and in any case it's not the syntax the OP asked
for; but it seems worth mentioning in this thread.

            regards, tom lane

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: function SETOF return type with variable columns?
Следующее
От: "Bill"
Дата:
Сообщение: Re: ADO/ODBC returns TEXT fields as Varchar, not LongVarChar