X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 04979D1ECF9 for ; Fri, 26 Mar 2004 21:30:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81136-04 for ; Fri, 26 Mar 2004 17:30:47 -0400 (AST) Received: from mail63.csoft.net (unknown [63.111.22.74]) by svr1.postgresql.org (Postfix) with SMTP id ED037D1ED08 for ; Fri, 26 Mar 2004 17:30:31 -0400 (AST) Received: (qmail 14825 invoked by uid 1112); 26 Mar 2004 21:31:34 -0000 Date: Fri, 26 Mar 2004 16:31:34 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: Dario Bahena Tapia Cc: pgsql-interfaces@postgresql.org Subject: Re: receiving user defined types from a function? In-Reply-To: <4060CE01.9080800@bsantander.com.mx> Message-ID: References: <4060CE01.9080800@bsantander.com.mx> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/34 X-Sequence-Number: 4813 On Tue, 23 Mar 2004, Dario Bahena wrote: > hi ... > > I've a postgresql function, that returns a user defined composite type, > is it posible to catch it using the jdbc driver???, cause then I tried > it and saw the class for the object, it gave me just the first member > for my composite type. > Instead of using a CallableStatement to call a function returning a complex type the recommended method is to use a regular Statement or PreparedStatement and simply call the function in a select such as: SELECT * FROM mycomplexfunction('a',12); Kris Jurka