Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 364E72E009E for ; Wed, 19 Dec 2007 11:23:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 50362-01 for ; Wed, 19 Dec 2007 11:23:08 -0400 (AST) Received: from insiderscore.com (mail01.insiderscore.com [69.84.139.233]) by postgresql.org (Postfix) with ESMTP id E1BA22E006D for ; Wed, 19 Dec 2007 11:23:19 -0400 (AST) Received: from [192.168.1.13] (mail01.insiderscore.com [69.84.139.233]) by insiderscore.com (Postfix) with ESMTP id 3DCCD9B0B30 for ; Wed, 19 Dec 2007 10:23:17 -0500 (EST) Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: <9A3471C2-F486-493B-89C5-E390904D74C9@torgo.978.org> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-sql@postgresql.org From: Jeff Trout Subject: DBLink or setof record functions & type shortcuts Date: Wed, 19 Dec 2007 10:23:16 -0500 X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/103 X-Sequence-Number: 29795 So I'm using dblink to run a query on another db, which works fine. I'm wondering if there is some shortcut I can use since I have the type the remote function is returning defined on my side so I don't need to list all the columns - so instead of select * from dblink('select * from someFooTypeReturningFunc()') as t1(col text, ....) I could write select * from dblink('select ... ') as t1(footype) I've poked over the docs and googled around, haven't seen anything yet. -- Jeff Trout http://www.dellsmartexitin.com/ http://www.stuarthamm.net/