> On 1/13/17 6:55 AM, Marko Tiikkaja wrote: >> On Fri, Jan 13, 2017 at 2:46 AM, Jim Nasby <jim.na...@bluetreble.com >> <mailto:jim.na...@bluetreble.com>> wrote: >> >> On 1/11/17 5:54 AM, Pavel Stehule wrote: >> >> + <term><varname>too_many_rows</varname></term> >> + <listitem> >> + <para> >> + When result is assigned to a variable by >> <literal>INTO</literal> clause, >> + checks if query returns more than one row. In this case >> the assignment >> + is not deterministic usually - and it can be signal some >> issues in design. >> >> >> Shouldn't this also apply to >> >> var := blah FROM some_table WHERE ...; >> >> ? >> >> AIUI that's one of the beefs the plpgsql2 project has. >> >> >> No, not at all. That syntax is undocumented and only works because >> PL/PgSQL is a hack internally. We don't use it, and frankly I don't >> think anyone should.
This submission has been moved to CF 2017-07. -- -David da...@pgmasters.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers