Обсуждение: Re: [PATCHES] PL/pgSQL: #option select_into_1_row (was SELECT INTO

Поиск
Список
Период
Сортировка

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

От
Bruce Momjian
Дата:
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. +


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

От
Tom Lane
Дата:
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


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

От
Bruce Momjian
Дата:
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. +