Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs
Date: 2003-07-23 23:06:06
Message-ID: 200307232306.h6NN66P01421@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Robert Treat wrote:
> On Wed, 2003-07-23 at 15:38, greg(at)turnstep(dot)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

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jamie Lawrence 2003-07-23 23:31:05 More plsql questions: updates on views
Previous Message Frank Bax 2003-07-23 20:45:24 strange "order by" request