Re: function SETOF return type with variable columns? - Mailing list pgsql-general

From Tom Lane
Subject Re: function SETOF return type with variable columns?
Date
Msg-id 11298.1219284514@sss.pgh.pa.us
Whole thread Raw
In response to Re: function SETOF return type with variable columns?  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: function SETOF return type with variable columns?  ("Merlin Moncure" <mmoncure@gmail.com>)
List 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 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: function SETOF return type with variable columns?
Next
From: "Bill"
Date:
Subject: Re: ADO/ODBC returns TEXT fields as Varchar, not LongVarChar