Re: function with multiple return values - Mailing list pgsql-general

Andreas Kretschmer <akretschmer@spamfence.net> writes:
> Scott Serr <serrs@theserrs.net> wrote:
>> Ideas on how to uniquely name the first and second set of "perc,
>> entry_date"?

> You can use alias-names for the 2 queries, like:

> test=*# select foobar.a as x, foobar.b as y, bar.* from (select * from foo()) foobar, (select * from foo()) bar ;

You don't really need the sub-selects: you can put aliases on functions
in FROM.

    select * from foo(...) as f1(a,b), foo(...) as f2(x,y);

            regards, tom lane