X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CD0DA475B85 for ; Wed, 30 Apr 2003 21:56:53 -0400 (EDT) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id 51BCD475A45 for ; Wed, 30 Apr 2003 21:56:53 -0400 (EDT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 19B3cs-00085U-00; Wed, 30 Apr 2003 20:16:46 -0600 Date: Wed, 30 Apr 2003 20:16:46 -0600 From: Roberto Mello To: Stephan Szabo Cc: Martin Chantler , pgsql-sql@postgresql.org Subject: Re: Stored Procedure Question Message-ID: <20030501021646.GD30405@cc.usu.edu> References: <3EAD2E0C@acw.co.uk> <20030430110028.I88465-100000@megazone23.bigpanda.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <20030430110028.I88465-100000@megazone23.bigpanda.com> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/463 X-Sequence-Number: 13164 On Wed, Apr 30, 2003 at 11:03:02AM -0700, Stephan Szabo wrote: > On Wed, 30 Apr 2003, Martin Chantler wrote: > > > Hi all, > > > > I am confused about Postgres stored procedures (aka functions), can they > > only return one value??? > > They could return sets, but before 7.3 the usefulness was limited > > > All examples I have seen don't return a recordset > > You might want to see > http://techdocs.postgresql.org/guides/SetReturningFunctions Hmm, this is cool. I can think of a couple documents I could contribute to this area over the summer. Is there a mailing list one can sign up to to be informed of new content in techdocs? That would be useful. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + CU = See You