X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DF7C538F7 for ; Wed, 6 Apr 2005 23:32:01 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28341-08 for ; Wed, 6 Apr 2005 22:31:53 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id AF2DB53221 for ; Wed, 6 Apr 2005 23:31:52 +0100 (BST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 515C330952; Thu, 7 Apr 2005 00:31:32 +0200 (MET DST) From: "Otto Blomqvist" X-Newsgroups: pgsql.sql Subject: Re: [GENERAL] Problems with Set Returning Functions (SRFs) Date: Wed, 6 Apr 2005 15:31:45 -0700 Organization: Hub.Org Networking Services Lines: 32 Message-ID: References: <5852.1112819444@sss.pgh.pa.us> X-Complaints-To: usenet@news.hub.org X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.456 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/142 X-Sequence-Number: 21035 Ofcourse this works perfectly ! Thanks a lot Tom ! Just curious, is this (x)-"trick" in the postgres manual somewhere ? Just just common SQL guru knowledge ? ;) /Otto Blomqvist "Tom Lane" wrote in message news:5852.1112819444@sss.pgh.pa.us... > "Otto Blomqvist" writes: > > secom=# select f1, f2, f3 from testpassbyval(1, (Select number1 from test)); > > ERROR: more than one row returned by a subquery used as an expression > > In 8.0 I think it'd work to do > > select (x).f1, (x).f2, (x).f3 from > (select testpassbyval(1, number1) as x from test) ss; > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >