X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 57E69D1C96F for ; Sat, 13 Mar 2004 02:47:49 +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 47555-06 for ; Fri, 12 Mar 2004 22:47:49 -0400 (AST) Received: from whowhere.com (in02-fes2.whowhere.com [209.202.220.219]) by svr1.postgresql.org (Postfix) with SMTP id B7084D1D2BC for ; Fri, 12 Mar 2004 22:47:44 -0400 (AST) Received: from Unknown/Local ([?.?.?.?]) by whowhere.com; Sat, 13 Mar 2004 02:47:37 -0000 To: pgsql-sql@postgresql.org Date: Fri, 12 Mar 2004 18:47:37 -0800 From: "William Anthony Lim" Message-ID: Mime-Version: 1.0 X-Sent-Mail: off Reply-To: wei.liang@eudoramail.com X-Mailer: MailCity Service X-Priority: 3 Subject: function returning resultset X-Sender-Ip: 202.155.67.13 Organization: Lycos Mail (http://www.mail.eudoramail.com) Content-Type: text/plain; charset=us-ascii Content-Language: en Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=BAYES_40, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: * X-Archive-Number: 200403/152 X-Sequence-Number: 17251 Hi, I'm using PGSQL 7.4.1 and JDBC 75dev client. I want to ask about PL/PGSQL function returning resultset. I read in the docs, there are 'setof' and 'refcursor' method, is there another method to returning resultset? What advantages and disadvantages for each method? Which is the best? Plz explain to me. Thx. W.A. Need a new email address that people can remember Check out the new EudoraMail at http://www.eudoramail.com