Andreas Kretschmer <[email protected]> writes:
> Scott Serr <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
