X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 25B59475CE7
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 17:01:05 -0500 (EST)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by postgresql.org (Postfix) with ESMTP id D02A0475A37
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 17:01:01 -0500 (EST)
Received: from [63.195.55.98] (HELO spooky)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 2820374; Sun, 02 Feb 2003 14:01:09 -0800
Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: "mail.luckydigital.com" <jim@luckydigital.com>
Subject: Re: PL/pgSQL question
Date: Sun, 2 Feb 2003 13:59:53 -0800
User-Agent: KMail/1.4.3
References: <01c301c2cb04$a6f27350$c900a8c0@jax>
In-Reply-To: <01c301c2cb04$a6f27350$c900a8c0@jax>
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Message-Id: <200302021359.53890.josh@agliodbs.com>
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/40
X-Sequence-Number: 11438

Jim,

> Yes i'm aware this it is possible in 7.3 - can someone please confirm its
> not possible in 7.2 or provide me with an example of how to go about it.

It is sort of possible in 7.2, as a function can return a cursor to an=20
interface language capable of handling cursors.   However, implementation i=
s=20
quite cumbersome, and I won't try to detail it here, particularly since tha=
t=20
language and method have been obsolesced and would force you to re-write yo=
ur=20
code when you do upgrade.

If this feature is important to you, I strongly recommend that you upgrade =
to=20
7.3.1 now.

--=20
Josh Berkus
Aglio Database Solutions
San Francisco