From jim@luckydigital.com Sun Feb  2 21:47:13 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4739F475425
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 16:47:13 -0500 (EST)
Received: from luckydigital.com (www.luckydigital.com [203.109.157.4])
	by postgresql.org (Postfix) with ESMTP id 3081E4753A1
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 16:47:12 -0500 (EST)
Received: from jax (203-109-198-1.akl.ihugultra.co.nz [203.109.198.1])
	by luckydigital.com (8.11.6/8.10.0) with SMTP id h12LlDC14337
	for <pgsql-sql@postgresql.org>; Mon, 3 Feb 2003 10:47:13 +1300
Message-ID: <01c301c2cb04$a6f27350$c900a8c0@jax>
From: "mail.luckydigital.com" <jim@luckydigital.com>
To: <pgsql-sql@postgresql.org>
Subject: 
Date: Mon, 3 Feb 2003 10:47:15 +1300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01C0_01C2CB71.9DB960B0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/39
X-Sequence-Number: 11437

This is a multi-part message in MIME format.

------=_NextPart_000_01C0_01C2CB71.9DB960B0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Can some one please confirm( with a plpgsql function example please ) a pos=
tgres "7.2" function that can return multiple rows to the client.

I've gone through the docs and can't find anything to support this -it seem=
s you can only have one return value or null.=20

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


Thank you.
------=_NextPart_000_01C0_01C2CB71.9DB960B0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>Can some one please confirm( with a plpgsq=
l=20
function example please ) a postgres "7.2" function that can return multipl=
e=20
rows to the client.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I've gone through the docs and can't find =
anything=20
to support this -it seems you can only have one return value or null.=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Yes i'm aware this it is possible in 7.3 -=
 can=20
someone please confirm its not possible in 7.2 or provide me with an exampl=
e of=20
how to go about it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thank you.</FONT></DIV></DIV></BODY></HTML>

------=_NextPart_000_01C0_01C2CB71.9DB960B0--




From josh@agliodbs.com Sun Feb  2 22:01:05 2003
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



From olly@lfix.co.uk Sun Feb  2 22:12:01 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 9FC8D4758DC
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 17:12:01 -0500 (EST)
Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net
	[194.217.242.90])
	by postgresql.org (Postfix) with ESMTP id 224AB475843
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 17:12:01 -0500 (EST)
Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk)
	by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1)
	id 18fSLK-000B8h-0W; Sun, 02 Feb 2003 22:12:02 +0000
Received: from localhost ([127.0.0.1] ident=olly)
	by linda.lfix.co.uk with esmtp (Exim 3.36 #1 (Debian))
	id 18fSLJ-0002dS-00; Sun, 02 Feb 2003 22:12:01 +0000
Subject: Re: 
From: Oliver Elphick <olly@lfix.co.uk>
To: "mail.luckydigital.com" <jim@luckydigital.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <01c301c2cb04$a6f27350$c900a8c0@jax>
References: <01c301c2cb04$a6f27350$c900a8c0@jax>
Content-Type: text/plain
Organization: LFIX Limited
Message-Id: <1044223921.32648.551.camel@linda.lfix.co.uk>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.1 
Date: 02 Feb 2003 22:12:01 +0000
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/41
X-Sequence-Number: 11439

On Sun, 2003-02-02 at 21:47, mail.luckydigital.com wrote:
> Can some one please confirm( with a plpgsql function example please )
> a postgres "7.2" function that can return multiple rows to the client.
>  
> I've gone through the docs and can't find anything to support this -it
> seems you can only have one return value or null. 
>  
> 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.

Not possible in 7.2 PL/pgSQL

-- 
Oliver Elphick <olly@lfix.co.uk>
LFIX Limited