X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 367AED1C7F1 for ; Thu, 31 Jul 2003 04:13:03 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 20530-01 for ; Thu, 31 Jul 2003 01:12:00 -0300 (ADT) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 8EE42D1C4E6 for ; Thu, 31 Jul 2003 01:13:01 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id h6V4CNt25172; Thu, 31 Jul 2003 00:12:23 -0400 (EDT) From: Bruce Momjian Message-Id: <200307310412.h6V4CNt25172@candle.pha.pa.us> Subject: Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs In-Reply-To: <200307232200.03736.xzilla@users.sourceforge.net> To: Robert Treat Date: Thu, 31 Jul 2003 00:12:23 -0400 (EDT) Cc: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/479 X-Sequence-Number: 14593 Does Oracle have a syntax for this? --------------------------------------------------------------------------- Robert Treat wrote: > On Wednesday 23 July 2003 19:06, Bruce Momjian wrote: > > Robert Treat wrote: > > > On Wed, 2003-07-23 at 15:38, greg@turnstep.com wrote: > > > > FOR myrec IN EXECUTE myinfo LOOP > > > > biglist := myrec.info; > > > > END LOOP; > > > > > > One other thing, I hate when I have to do things like the above, can we > > > get a TODO like: > > > > > > allow 'EXECUTE var INTO record' in plpgsql > > > > So the TODO would be? > > > > Allow PL/pgSQL EXECUTE to return a single record outside a loop > > that's what I wrote, but not what I meant :-) I do like the sound of it > though, but really what I meant to say was: > EXECUTE var1 INTO var2 > but this assumes a number of things, namely that executing var1 will return > only one field, and one row. I guess that would be: > Allow PL/pgSQL EXECUTE to return a single variable outside a loop > > Robert Treat > -- > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073