2010/11/7 Scott Serr <serrs@xxxxxxxxxxxx>: > On 11/07/2010 08:53 AM, Tom Lane wrote: >> >> Andreas Kretschmer<akretschmer@xxxxxxxxxxxxx> Âwrites: >>> >>> Scott Serr<serrs@xxxxxxxxxxxx> Â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 >> > > Thanks Tom, Andreas, and Osvaldo... > > I've found I really need these on the Select part rather than the From. > > select otherstuff.*, foo(...) as f1(a,b), foo(...) as f2(x,y) from > otherstuff; > ...won't work. ÂIt says: > Â Â subquery must return only one column > > Funny thing is > Â select (foo(...)).*, (foo(...)).*; > ...works fine, just has duplicate column names, so they are hard to get at. Attention: this syntax is great, but function is evaluated for every column one times! Regards Pavel Stehule > > I modeled this after examples here > http://www.postgresonline.com/journal/index.php?/archives/129-Use-of-OUT-and-INOUT-Parameters.html > > I really only want a single record back from my function, but the > multi-record return looked easier. I need some kind of control of how the > columns are named per call. > > Maybe this isn't possible... Ânot alot of docs in this area. > > Thanks, > Scott > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
