Mark Gibson wrote:
> I'd like to do something like this:
>
> CREATE TYPE my_type AS (id integer, title text);
>
> SELECT *
> FROM fn_returning_setof_record( ... )
> AS t my_type;
> or
> SELECT *
> FROM fn_returning_setof_record( ... )::my_type AS t;
> I've not been able to find anything like this in the docs.
> Is there currently any way of doing this? are there any plans for it?
There is no way to do this now, and no plans that I know of, but it does
look useful. I'm not sure how painful it would be to make it happen
though...
Joe