Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: Joe Conway <mail@joeconway.com>
Subject: Re: TODO items
Date: Thu, 7 Aug 2003 21:35:01 -0700
User-Agent: KMail/1.4.3
Cc: Bruce Momjian <pgman@candle.pha.pa.us>,
	PostgreSQL-development <pgsql-hackers@postgreSQL.org>
References: <200308080201.h78212x26726@candle.pha.pa.us>
	<200308072036.22437.josh@agliodbs.com>
	<3F33205C.6040308@joeconway.com>
In-Reply-To: <3F33205C.6040308@joeconway.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200308072135.01205.josh@agliodbs.com>

Joe,

> They are done (at least the array declarations and array element
> assignment part):

Way cool!  How'd I miss that one?

Time to test ....

> >>        o Add PL/PgSQL PROCEDURES that can return multiple values
> >
> > Hmmm ... I know how this got on the TODO, but it's a fragment of a larger
> > suggestion about PROCEDURES vs. FUNCTIONS.   I don't think it makes much
> > sense on its own without the other elements; maybe we should take it off
> > until I can make a full proposal?
>
> Is this somehow different from table functions (SRFs)?

Yes.   Reference T-SQL's OUTPUT parameters.

Mind you, with the implementation of SRFs, it's not as necessary as it once 
was.

> Pretty much sure this has not been done. I'll be happy to work with
> someone if they want to pick this up, but I don't use them enough to
> feel comfortable doing it myself.

I'd be happy to test PL/Perl.  I won't be any help with the others ...

-- 
Josh Berkus
Aglio Database Solutions
San Francisco