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 745CED1EC49 for ; Tue, 23 Mar 2004 23:56:02 +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 93017-01 for ; Tue, 23 Mar 2004 19:56:01 -0400 (AST) Received: from mailpro02.santander.com.mx (unknown [170.169.46.21]) by svr1.postgresql.org (Postfix) with ESMTP id 5F738D1E9C6 for ; Tue, 23 Mar 2004 19:55:55 -0400 (AST) Received: from mailpro02.santander.com.mx (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id E5FEB44A3F for ; Tue, 23 Mar 2004 17:55:03 -0600 (CST) Received: from mailpro1 (mailpro1 [180.176.11.1])by mailpro02.santander.com. mx (Postfix) with ESMTP id B5BA64493Dfor ; Tue, 23 Mar 2004 17:55:03 -0600 (CST) Received: from mailpro1.mx.bsch (mailpro1 [180.176.11.1])by mailpro1.mx.bsch (iPlanet Messaging Server 5.2 Patch 1 (built Aug 19 2002))with ESMTP id <0 HV2006SW07538@mailpro1.mx.bsch> forpgsql-interfaces@postgresql.org; Tue, 23 Mar 2004 18:04:17 -0600 (CST) Received: from mailpro1.mx.bsch (localhost [127.0.0.1])by localhost.santande r.com.mx (Postfix) with ESMTP id 2A8A63704D for; Tue, 23 Mar 2004 18:04:17 -0600 (CST) Received: from bsantander.com.mx (unknown [180.175.192.111])by mailpro1.mx.b sch (Postfix) with ESMTP id D63963704A for ; Tue, 23 Mar 2004 18:04:16 -0600 (CST) Date: Tue, 23 Mar 2004 17:53:37 -0600 From: Dario Bahena Subject: receiving user defined types from a function? To: pgsql-interfaces@postgresql.org Reply-To: Dario Bahena Tapia Message-id: <4060CE01.9080800@bsantander.com.mx> Organization: Banco Santander Mexicano MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6)Gecko/200 40113 X-imss-version: 2.0 X-imss-result: Passed X-imss-scores: Clean:25.91882 C:20 M:1 S:5 R:5 X-imss-settings: Baseline:3 C:3 M:3 S:4 R:3 (0.0500 0.1500) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/32 X-Sequence-Number: 4811 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. Maybe I can return a refcursor which should be mapped to a ResultSet in java ... but my functions would look less natural, in fact, I've already changed them cause PostgreSQL doesn't support out parameters. Thankx. salu2 dario estepario ...