Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D1236476B57
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 18:20:30 -0400 (EDT)
Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56])
	by postgresql.org (Postfix) with ESMTP id C0E16476B41
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 18:20:26 -0400 (EDT)
Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian))
	id 182fcF-0003z6-00; Fri, 18 Oct 2002 16:29:11 -0600
Date: Fri, 18 Oct 2002 16:29:11 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: Brian <bill@digitalpitstop.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: functions that return a dataset or set of rows
Message-ID: <20021018222911.GF14753@cc.usu.edu>
References: <aofqbd$10v5$1@news.hub.org> <aomc69$17h0$1@news.hub.org>
	<3DAF2E82.8020600@digitalpitstop.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <3DAF2E82.8020600@digitalpitstop.com>
User-Agent: Mutt/1.4i
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/250
X-Sequence-Number: 9967

On Thu, Oct 17, 2002 at 05:41:22PM -0400, Brian wrote:
> Is it not possible in 7.2?

In 7.2 you can return a cursor, which gets close and lets you basically
accomplish the goal.

See the PL/pgSQL developer documentation for 7.3 (returning cursors was 
omitted accidentally (?) in the 7.2 documentation).

http://developer.postgresql.org/

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
Bill Gates made $6.3 Billion selling us MS-DOS?