X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 165EF475CE5 for ; Wed, 30 Apr 2003 14:03:07 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id D6C45475B8E for ; Wed, 30 Apr 2003 14:03:02 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id C99C2D62A; Wed, 30 Apr 2003 11:03:02 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id BF4B15C0A; Wed, 30 Apr 2003 11:03:02 -0700 (PDT) Date: Wed, 30 Apr 2003 11:03:02 -0700 (PDT) From: Stephan Szabo To: Martin Chantler Cc: Subject: Re: Stored Procedure Question In-Reply-To: <3EAD2E0C@acw.co.uk> Message-ID: <20030430110028.I88465-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-26.0 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REPLY_WITH_QUOTES 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/460 X-Sequence-Number: 13161 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