Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 89A1EB5DBD0 for ; Tue, 5 Jul 2011 06:07:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 77561-02 for ; Tue, 5 Jul 2011 09:07:46 +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 4317AB5DBCA for ; Tue, 5 Jul 2011 06:07:46 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Qe1bd-0000wW-Oh for pgsql-sql@postgresql.org; Tue, 05 Jul 2011 02:07:45 -0700 Date: Tue, 5 Jul 2011 02:07:45 -0700 (PDT) From: gmb To: pgsql-sql@postgresql.org Message-ID: <1309856865759-4552618.post@n5.nabble.com> In-Reply-To: References: <1309762075448-4549140.post@n5.nabble.com> <868vseduyv.fsf@mgm.protecting.net> <1309787989162-4550092.post@n5.nabble.com> <1309854073767-4552513.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/8 X-Sequence-Number: 35578 Pavel Stehule wrote: > > > npcps_201=# select * from (select 1,2,2,3) x (a,b,c,d); > > That is a neat trick - one I didn't know of. Thanks Pavel -- View this message in context: http://postgresql.1045698.n5.nabble.com/Usage-of-function-retruning-record-in-query-tp4549140p4552618.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.