Re: PL/pgSQL: #option select_into_1_row (was SELECT INTO - Mailing list pgsql-patches

From Matt Miller
Subject Re: PL/pgSQL: #option select_into_1_row (was SELECT INTO
Date
Msg-id 1123599690.3231.4.camel@dbamm01-linux
Whole thread Raw
In response to Re: PL/pgSQL: SELECT INTO EXACT  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PL/pgSQL: #option select_into_1_row (was SELECT INTO
Re: PL/pgSQL: #option select_into_1_row (was SELECT INTO
List pgsql-patches
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.

Is it time to document this directive?

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fix oversight in pts_error_callback()
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] O_DIRECT for WAL writes