Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id AD0FDB5DBE6 for ; Tue, 5 Jul 2011 05:21:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 40956-02 for ; Tue, 5 Jul 2011 08:21:14 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 713B9B5DBCB for ; Tue, 5 Jul 2011 05:21:14 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Qe0sb-00053E-P0 for pgsql-sql@postgresql.org; Tue, 05 Jul 2011 01:21:13 -0700 Date: Tue, 5 Jul 2011 01:21:13 -0700 (PDT) From: gmb To: pgsql-sql@postgresql.org Message-ID: <1309854073767-4552513.post@n5.nabble.com> In-Reply-To: <1309787989162-4550092.post@n5.nabble.com> References: <1309762075448-4549140.post@n5.nabble.com> <868vseduyv.fsf@mgm.protecting.net> <1309787989162-4550092.post@n5.nabble.com> Subject: Re: Usage of function retruning record in query MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.767 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201107/6 X-Sequence-Number: 35576 gmb wrote: > > > Thanks for the feedback, Harald. > > How about specifying different aliases to the resulting values? > This will be handy when I use the same function multiple times in the same > query. > (the function will take another input parameters used in the calculations) > > E.g.: > SELECT itemid, (calcvalues(itemid, '2011-06-06')).*, (calcvalues(itemid, > '2011-06-07')).* FROM itemlist; > > itemid | calcval1 | calcval2 | calcval1 | calcval2 > --------+----------+----------+----------+---------- > 4 | 0.67 | 10.00 | 0.64 | 65.23 > 5 | 1.55 | 45.00 | 1.23 | 23.25 > 6 | 3.60 | 69.00 | 2.98 | 62.66 > How will I manage unique column names for this output? > Hmm.. no takers? I guess not possible then? Thanks anyway -- View this message in context: http://postgresql.1045698.n5.nabble.com/Usage-of-function-retruning-record-in-query-tp4549140p4552513.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.