Received: from mail.taxrefund.com (willy.pdq.net [216.88.69.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7F2apP15336 for ; Tue, 14 Aug 2001 22:36:51 -0400 (EDT) (envelope-from rsanford@nolimitsystems.com) Received: from mightywombat [66.25.23.179] by mail.taxrefund.com (SMTPD32-7.00) id A04B10100C6; Tue, 14 Aug 2001 21:36:59 -0500 From: "Robert J. Sanford, Jr." To: Subject: result sets from functions... Date: Tue, 14 Aug 2001 21:35:56 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-Archive-Number: 200108/199 X-Sequence-Number: 4431 i'm reading the postgres documentation and i'm specifically interested in creating stored procedures so that i can keep as much of the business logic in the database as possible. while reading 13.1.3 (SQL Functions on Composite Types) in the Programmer's Guide i come across the phrase... "When calling a function that returns a row, we cannot retrieve the entire row. We must either project an attribute out of the row or pass the entire row into another function. SELECT name(new_emp()) AS nobody;" how does this affect calling functions as stored procedures from the jdbc driver and getting a result set returned bac? am i allowed to use Connection.PrepareCall() to create a CallableStatement against a postgres function and receive a ResultSet that can be iterated over? thanks! rjsjr