Thread: Re: [PATCHES] PL/pgSQL: #option select_into_1_row (was SELECT INTO

Matt Miller wrote:
> On Mon, 2005-08-08 at 17:18 -0400, Tom Lane wrote:
> > If you think that this should be a global option instead of a
> > per-statement one, something like the (undocumented) #option hack might
> > be a good way to specify it; that would give it per-function scope,
> > which seems reasonable.
> > 
> >     create function myfn(...) returns ... as $$
> >         #option select_into_1_row
> >         declare ...
> >     $$ language plpgsql;
> 
> Attached is a patch that implements the "#option select_into_1_row"
> directive as suggested.

Are we agreed this is the way we want to control this?

--  Bruce Momjian   http://candle.pha.pa.us SRA OSS, Inc.   http://www.sraoss.com
 + If your life is a hard drive, Christ can be your backup. +

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Are we agreed this is the way we want to control this?

AFAICT, no one except Matt wants this feature at all, so I'd much prefer
to drop the whole idea.  I think it's a insufficiently justified kluge.
        regards, tom lane

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Are we agreed this is the way we want to control this?
> 
> AFAICT, no one except Matt wants this feature at all, so I'd much prefer
> to drop the whole idea.  I think it's a insufficiently justified kluge.

Fine.  Unless I hear from the non-kludge croud, it is dropped.  ;-)

--  Bruce Momjian   http://candle.pha.pa.us SRA OSS, Inc.   http://www.sraoss.com
 + If your life is a hard drive, Christ can be your backup. +