| From: | Matt Miller <mattm(at)epx(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: PL/pgSQL: #option select_into_1_row (was SELECT INTO |
| Date: | 2005-08-09 15:01:29 |
| Message-ID: | 1123599690.3231.4.camel@dbamm01-linux |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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 | Content-Type | Size |
|---|---|---|
| select_into_1_row.patch | text/x-patch | 4.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-09 15:34:32 | Re: Solving the OID-collision problem |
| Previous Message | Richard Huxton | 2005-08-09 15:01:14 | Re: Solving the OID-collision problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | joshua masiko | 2005-08-09 19:40:27 | BUG #1815: ECPGdebug causes crash on Windows XP |
| Previous Message | Tom Lane | 2005-08-09 14:38:25 | Re: Fix oversight in pts_error_callback() |