X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C02419DC890 for ; Sun, 19 Mar 2006 09:32:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16607-09 for ; Sun, 19 Mar 2006 09:32:46 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.199]) by postgresql.org (Postfix) with ESMTP id 893619DC821 for ; Sun, 19 Mar 2006 09:32:40 -0400 (AST) Received: by nproxy.gmail.com with SMTP id l37so640255nfc for ; Sun, 19 Mar 2006 05:32:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=googlemail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SHf2ODKt2ZgQpwQ9l6FsZOiS19UiJqr/cdhbVVx3CVyypOQf+tE0iolSusBpPRtwuexMefDoFawhv0VW0HYPsNavzA01LODU4GApsPBBE/3siTHiV7Xwl/UrkEeFlOXZY8L07OrxbZhoMiUcgcTaNE3FDHYgZjDI3qFbD3n/bs4= Received: by 10.49.1.4 with SMTP id d4mr2337853nfi; Sun, 19 Mar 2006 05:32:43 -0800 (PST) Received: by 10.49.1.16 with HTTP; Sun, 19 Mar 2006 05:32:43 -0800 (PST) Message-ID: <684362e10603190532p1903fca8p@mail.gmail.com> Date: Sun, 19 Mar 2006 19:32:43 +0600 From: "Markus Bertheau" To: "Svenne Krap" Subject: Re: How to call table returning function with other table Cc: pgsql-sql@postgresql.org In-Reply-To: <441D5C14.8010204@krap.dk> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <441D5C14.8010204@krap.dk> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.118] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200603/275 X-Sequence-Number: 24621 2006/3/19, Svenne Krap : > So it is something like "select xxx(id) from othertable where otherwhere > =3D 't'" except that it mangles the columns into an array. I have tried t= o > move the function-call into the fromlist (as it is usually done) but I > seem unsuccessful in getting the ID's into it. You have to use something like SELECT (xxx(id)).* FROM othertable WHERE otherwhere =3D 't', I believe. Markus Bertheau