This is a discussion on Re: [PATCHES] PL/pgSQL: #option select_into_1_row (was SELECT INTO within the pgsql Hackers forums, part of the PostgreSQL category; --> Matt Miller wrote: > On Mon, 2005-08-08 at 17:18 -0400, Tom Lane wrote: > > If you think that ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |